bBox_SplitText

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

Parameters:
   text: source text to split
   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

---

This function will return a version of the source text with the separator(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.

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

As an example, if $text contains:

1:Adrian Banks:volutpat.nunc.sit@In.com:415-839-0000
2:Addison Nunez:Donec.tempor@facilisiSedneque.org:
3:Alejandro Bizbaz::
4:Juram Yuring::510-555-1212
5:::

We can have a function call to replace (or keep) a line break at every colon character or every return character:

bBox_SplitText ($text; 0; 9999; 0; ":"; ¶; ¶)

The result is:

Adrian Banks
volutpat.nunc.sit@In.com
415-839-0000
2
Addison Nunez
Donec.tempor@facilisiSedneque.org

3
Alejandro Bizbaz


4
Juram Yuring

510-555-1212
5

But by changing skipRepeats to 1 we get a result with the blank lines (eg, consecutive return characters) removed:

1
Adrian Banks
volutpat.nunc.sit@In.com
415-839-0000
2
Addison Nunez
Donec.tempor@facilisiSedneque.org
3
Alejandro Bizbaz
4
Juram Yuring
510-555-1212
5