« Easy Example Of The FileMaker Let Function | Main | FILEMAKER: IsNumberInRange By Ibrahim Bittar Torres, Eikonsys »
Friday
Mar262010

FILEMAKER: WordPosition Custom Function By Daniele Raybaudi, ACI

© 2010 Dwayne Wright - dwaynewright.com

From Dwayne Wright PMP - Certified FileMaker 10, 9 & 8 Developer
EMAIL: info@dwaynewright.com     TWITTER: dwaynewright

CHAPTER 20: Custom Functions

Came across another parsing related custom function this week that I wanted to share with you. This one is called WordPosition found at briandunning.com and uploaded by Daniele Raybaudi, ACI. Here is a direct link where you can find it ...

http://www.briandunning.com/cf/474

The project that I’m working on is parsing pdf versions of multiple column documents created by InDesign. In each piece of data I copy, I might have to populate 30 - 40 fields. In some cases, I have to detect for strings within the text that will ultimately reside in portals.

In my latest task, I’m taking the entire string of data and slicing them into individual portal rows. Then I’m addressing each portal row one at a time. In this implementation, the WordPosition function is very helpful. I can look for a label and then use the left, right and middlewords functions.

In hindsight, I’m kind of amazed FileMaker doesn’t provide a core WordPosition function.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>