Brian Dunning's FileMaker Custom Functions

MiddleTransform ( _text ; _delimiter ; _occurrance ; _newdelimiter )

Grabs all text from a variable starting delimiter and to the end of the field with the possibility to substitute the new text with a different delimiter.

  Average rating: 4.5 (32 votes) Log in to vote

Andreas Goude   Andreas Goude
No Company
http://nocompany.com

Share on Facebook Share on Twitter

  Sample input:
MiddleTransform ( "205|chuck|liddell|1969|San Luis Obispo|Santa Barbara|The Iceman" ; "|" ; 3 ; "¶" )
  Sample output:
1969
San Luis Obispo
Santa Barbara
The Iceman

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

Grabs all text from a variable starting delimiter and to the end of the field with the possibility to substitute the new text with a different delimiter.

 

Comments

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: