bBox_SplitText( text; position; length; skipRepeats; seperator1; seperator2; delimiter )

Given some source text, this function will return a version of the text with the seperator(s) replaced with the delimiter. This is commonly used to "split" text into  lines by using the line delimiter (CR usually for FileMaker). Only the substring of text within the given position and length is processed.

Parameters:
   text: source texttext: sent to NodeJS' stdin
   position: index into source text to start scan
   length: index of last character to scan
   skipRepeats: true if no seperator should be added if there are adjoining seperators
   seperator1: first seperator text to use; often a tab or space
   seperator2: second seperator; often a return/newline
   delimitor: text to add for matching seperators

Output
   result of scanned text after substitution

Error:
   none

––––––––––

First appeared in: 0.99

Examples in demo file: 1

Compatibility:   Client, Server, macOS, Ubuntu, Server, WebDirect, WPE

––––––––––

Although similar to FileMaker's native Substitute function, this function can easily work with substrings. It also handles cases where adjacent seperators should be treated as a single seperator, such as where one or more space characters are used between values.

––––––––––

bBox Functions

bBox Wiki