Text Parsing in FileMaker : Live Demo - Example 1

[LindeeGVideos]

Great demo! The Middle fx doesn't seem to be very transportable here to finding other names in the text block because some are delimited "," & others ", ". Wouldn't this be a good time to throw in Trim? By adding 1 & using Trim you can cover for data inconsistencies.

BTW, love your videos - very concise, short, & sweet. Excellent examples! Keep them coming - even those of us who have been doing FIlemaker for a long time appreciate them.

[chadadams0]

reviewedtv,

You are absolutely right and that is in fact what we do in the example 2 video.

The purpose here wasn't to find the best way to get to the 6th person's initials, but rather to demonstrate how to use the functions talked about in earlier videos in conjunction with each other.

Chad

[reviewedtv]

This could be solve much easier by manipulating the text and pulling your desired value.

Let ( [ string = "John Doe, Tom Jones, Mary Smith, Samantha Times, Sam Green"; values = Substitute ( string ; "," ; ¶ )

]; GetValue ( values ; 4 )

)