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 - Show more from this author
https://www.linkedin.com/in/dougstaubach/

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)

//created Feb 1, 2014 by Doug Staubach
//converts "Andrew ( Dice ) Clay, Jr" to "Andrew¶Dice¶Clay¶Jr"
//designed especially for handling proper names (strips punctuation)

Substitute(Trim(Substitute(FormattedText;["¶";" "];["(";" "];[")";" "];["[";" "];["]";" "];["{";" "];["}";" "];["<";" "];[">";" "];["~";" "];["`";""];["!";" "];["@";" "];["#";" "];["$";" "];["%";" "];["^";" "];["&";" "];["*";" "];["_";" "];["-";" "];["+";" "];["=";" "];["|";" "];["'";" "];["'";" "];["\\";" "];["/";" "];["\"";" "];["?";" "];[".";" "];[",";" "];[";";" "];[":";" "];["  ";" "]));["  ";" "];[" ";"¶"])

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

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

TextToValues ( FormattedText )

Comments

Support this website.

Support this website.