Text Parsing in FileMaker : Live Demo - Example 1

FileMaker Certified Developer Chad Adams has prepared a series of short videos that describe the robust text parsing capability available in FileMaker Pro 10. This video ties together Chad's previous explorations of individual functions it's a great live demonstration of a real world application for text parsing.

Text functions allow FileMaker Pro to deal with text strings in a meaningful way. A database cannot see the value in a word or sentence. What it can see is an collection of characters strung together like beads on a necklace. Punctuation and white space carry the same a value as letters and numbers. As you develop solutions in FileMaker Pro understanding how to manipulate these strings of text is imperative.

Category:

Science & Technology

Tags:

• Filemaker
• text parsing
• database
• demo
• sony
• ninja
• game
• tutorial
• finance
• programs
• cybersecurity
• technology
• electronics
• economy
• music charts
• vlog
• installation
• educational
• tips & tricks
• software
• market
• demonstration
• business
• need
• help

[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 )

)