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
XYZ Co.
http://www.website.com

Sample input:

GetValueCust("123^^^^^456^^^abc";2)

Sample output:

456

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let(
[
count = PatternCount ( text ; delimiter );
values = count + 1;
strlen = Length(text);
delLength = Length(delimiter)
];

Case(
text = ""; "";
count = 0; "";
number > values; "";
number < 1; "";
number = 1 and values = 1; text;
number = 1; Left(text; Position(text;delimiter;0;1) - 1);
number = values; Right(text;strlen - ((Position(text;delimiter;0;number - 1) + delLength)) + 1);
Middle ( text ; Position(text;delimiter;0;number - 1) + Length(delimiter); (Position(text;delimiter;0;number) - 1) - (Position(text;delimiter;0;number - 1) + (Length(delimiter) - 1)))
)
)

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, 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 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 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.

GetValueCust ( text ; delimiter ; number )

Comments

Support this website.

Support this website.