Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6280 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi i would like to strip out the vowels from a string.

Thats fairly easy but to make the resultant string fairly readable I need the first letter of any separate word to keep the vowel.

eg Office: Academic

=

Offc: Acdmc

any ideas? thanks

Posted

Sounds like a job for a recursive custom function. It nds t lv th frst lttr of ech wrd bt strp th vwls frm th rst of th wrd.

Posted

Thanks guys - I can see custom functions is something I need to pay some attention to

Posted (edited)

Just for fun. A "simple" calculation... but please do not find too many word separators ! (handled blank, CR and dash).

A recursive function has its limit for long texts.

stripVowel2.fp7.zip

Edited by Guest
Posted

You should also pay attention to your profile - I would not suggest a custom function to you, unless you indicated you have Advanced.

BTW, if all the words are in title case as in your example, it's a simple matter of substituting out all lower-case vowels (the Substitute function is case-sensitive).

Posted (edited)

Hello !

I like Substitute and I like Evaluate Too...

I try this Calculation

Let ([

listA =

"a|a e|e i|i o|o u|u y|y A|A E|E I|I O|O U|U Y|Y à|à â|â ä|ä ö|ö ô|ô ù|ù ï|ï é|é è|è ê|ê" ; // Charge Letter|LetterSpaceLetter|Letter

Result = "["" &

Substitute ( listA ; [ "|" ; "";"|" ] ; [ " " ; ""] ; ["" ] ) & ""] ;

[ " |" ; " " ] ; [ "-|" ; "-"] ; [" & quote(¶ & "|") & ";" & quote(¶) & "] ; ["|"

& Substitute ( listA ; [ "|" ; "";""/*" ] ; [ " " ; "*/] ; ["|" ] ) & ""*/] ; ["§ " ; ""] )"

];

Evaluate ( "Substitute ( "§ " & stripVowel::txt ; " & Result )

)

"Just for fun too" :)

Agnès

------------------------

[Try to Explain "Result"

Substitute ( listA ; [ "|" ; "";"|" ] ; [ " " ; ""] ; ["" ] ) & ""] ; <- This part substitute a by |a, e by |e ....

[ " |" ; " " ] ; [ "-|" ; "-"] ; [" & quote( & "|") & ";" & quote(¶) & "] ; <- This part for space; "-" or ¶ to preserve the first letter ( to locate space, "-" or ¶ in left of a word )

; ["|" & Substitute ( listA ; [ "|" ; "";""/*" ] ; [ " " ; "*/] ; ["|" ] ) & ""*/] ; <- This part substitute a by nothing, e by nothing ....

["§ " ; <- And this one for the first blank

]

Edited by Guest
.....

This topic is 6280 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.