Brian Dunning's FileMaker Custom Functions

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

Dubi Doo   Dubi Doo
XYZ Co.
http://www.website.com

Share on Facebook Share on Twitter

  Sample input:
GetValueCust("123^^^^^456^^^abc";2)
  Sample output:
456

  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.

 

Comments

Bart Bartholomay   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 '^'.
 
Bruce Robertson   Bruce Robertson
Jan 17, 2010
Looks like two problems in the example input. No delimiter specified; inconsistent delimiter length. Shouldn't your example input be:
GetValueCust("123^^^456^^^abc";"^^^"; 2)
 
David   David
Jan 25, 2010
I posted a new an MUCH simpler function. This one is ridiculous
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: