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.