Left_Or_Right_Chars_Of_Every_Word ( Direction ; Text ; Chars ; Separator )

Extracts n chars of every word in Text from left or right side.

Be the first to rate this function Log in to vote

Jesus Sanchez - Show more from this author
dbFile Desarrollos
http://www.dbfile.es

Sample input:

Left_Or_Right_Chars_Of_Every_Word ( "left" ; "Lorem ipsum dolor sit amet, consectetur" ; 3 ; "¶")

Sample output:

Lor
ips
dol
sit
ame
con

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*

By Jesús Sánchez - dbFile  - info@dbfile.es
last modified at Dec 14 2022

Purpose: Extracts n chars of every word in Text from left or right side.

Params:  

   Direction: Right or Left ( not case sensitive ). Default Left.
   Text: Text for work.
   Chars: Number of characters to extract.
   Separator: Separation char.

Example:

   Left_Or_Right_Chars_Of_Every_Word ( "left" ; "Lorem ipsum dolor sit amet, consectetur" ; 3; "¶" )

   Returns:

   Lor
   ips
   dol
   sit
   ame
   con


   Left_Or_Right_Chars_Of_Every_Word ( "Right" ; "Lorem ipsum dolor sit amet, consectetur" ; 4 ; " " )

   Returns: orem psum olor sit amet etur 

*/


// NOTE: While only works on FileMaker 18 or above.


While ( 

[ 
~Text = Text ;
~WordCount = WordCount ( ~Text ) ;
~Result = "" ;
~Counter = 0
] ; 

~Counter < ~WordCount ; 


[
~Counter = ~Counter + 1 ;
~Result = 

		If ( Direction = "Right" ; ~Result & Right ( MiddleWords ( ~Text ; ~Counter ; 1 ) ; Chars ) & Separator ; ~Result & Left ( MiddleWords ( ~Text ; ~Counter ; 1 ) ; Chars ) & Separator )

]  ; 


~Result )

Developed to hide personal data in FileMaker files.

Comments

		Jesus Sanchez, dbFile Desarrollos Dec 13, 2022
You can leave empty Direction parameter: Left_Or_Right_Chars_Of_Every_Word ( "" ; "Lorem ipsum dolor sit amet, consectetur" ; 4 ; " " ) and you get: Lore ipsu dolo sit amet cons

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Left_Or_Right_Chars_Of_Every_Word ( Direction ; Text ; Chars ; Separator )

Comments

Support this website.

Support this website.