in Advanced PDF Templates, how do I split a string by its line breaks?

AI generated answer (using internal Slack threads):

In Advanced PDF Templates, to split a string by its line breaks, you can use the

split

function in combination with a regular expression that matches line breaks. Here is an example of how you can do this: First, you need to replace the line breaks in your string with a unique character or string that does not occur in your data. You can use the

TRANSLATE

function in a formula text field in your saved search for this. Here is an example:

javascript
TRANSLATE({address_field}, chr(10), '|')

In this example,

address_field

is the field that contains the string you want to split,

chr(10)

represents a line break, and

'|'

is the unique character that you are replacing line breaks with. Then, in your Advanced PDF Template, you can split the string by this unique character using the

replace

function. Here is an example:

javascript
${result.formulatext?replace("|","<br />")}

In this example,

result.formulatext

is the result of the

TRANSLATE

function in your saved search,

'|'

is the unique character that you replaced line breaks with, and

"<br />"

is the HTML tag for a line break. Please note that this method requires you to modify your saved search. If you want to split the string only on the PDF template side, you might need to use a different method. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******