GetValueCust ( text ; delimiter ; number )
Retrieve a value from a valueList using a delimiter other than ¶
Average rating: 4.5 (32 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This is a good function to use when you are storing a record contents in a single field, where a field may contains line breaks. For instance, the data:
"`````This is the first field data
It has paragraph breaks in it.`````Not to worry, use a different delimiter with this function and you can retrieve it with no problem."
Can be stored and retrieved, value by value with this function.
|Bart Bartholomay, Vero Beach, FL
Jan 16, 2010
|In the example parameters you're using you fail to include a delimiter. You're CF calls for three parameters and you're using just the text and the number, but not the '^'.|
Jan 17, 2010
|Looks like two problems in the example input. No delimiter specified; inconsistent delimiter length. Shouldn't your example input be:
Jan 25, 2010
|I posted a new an MUCH simpler function. This one is ridiculous|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.