Brian Dunning's FileMaker Custom Functions

TextToValues ( FormattedText )

Quickly converts a text string into a list of values (removing all delimiters) no recursion

  Average rating: 4.4 (26 votes) Log in to vote

Doug Staubach   Doug Staubach
FileMaker Poweruser
https://www.linkedin.com/in/dougstaubach

Share on Facebook Share on Twitter

  Sample input:
Robert (Jack) Kennedy, Jr.
James|"Jimmy-John"|Jackson
R/L/Stine
Jonathan Q. Adams
  Sample output:
Robert¶Jack¶Kennedy¶Jr¶
James¶Jimmy¶John¶Jackson¶
R¶L¶Stine¶
Jonathan¶Q¶Adams¶

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

Quickly converts a single text string into multiple parts ](removing all formatting and punctuation characters in the process).

Does not have any recursion; works with older versions of FileMaker Pro.

 

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.

Under construction. Email me your wish list for improvements.