[FP5] formatting text via script

[R. McFarlane]

Hello all,

I need to format a field so that it contains the first 2 letters of each word from another field. I have not needed to do this before and I can not figure it out other than it looks like I need to use a script to perform some sort of "strip text" to obtain the results.

Thanks in advance!

FileMaker Version: 5

Platform: Mac OS 9

[-Queue-]

Here are two ways to do this.

One: Create a calculation field of

Left( MiddleWords( text, 1, 1 ), 2 ) &

Left( MiddleWords( text, 2, 1 ), 2 ) &

Left( MiddleWords( text, 3, 1 ), 2 ) &

Left( MiddleWords( text, 4, 1 ), 2 ) &

Left( MiddleWords( text, 5, 1 ), 2 ) &

Left( MiddleWords( text, 6, 1 ), 2 ) &

Left( MiddleWords( text, 7, 1 ), 2 ) &

Left( MiddleWords( text, 8, 1 ), 2 ) &

Left( MiddleWords( text, 9, 1 ), 2 ) &

Left( MiddleWords( text, 10, 1 ), 2 )

You can vary the middle parameter of MiddleWords, depending on how many you need.

Two: check the attachment for a valuelist based on a repeating field calculation.

McFarlane_rep_word.zip

[R. McFarlane]

Thank you for the quick reply!

Am I correct in thinking that the numbers 1 - 10 are to calculate up to 10 words?

Thanks in advance!

FileMaker Version: 5

Platform: Mac OS 9

[-Queue-]

Yes, you are correct.