Replace comma with linebreak


#1

Let's say I have an address:

place name, name of the street, city, postcode

I want to copy it into the clipboard, but then replace the commas with a comma+line break in the following formula:

{address={clipboard}}{formparagraph: name=address; width=40; height=6}

How do I use the replace command in there?

Thanks


#2

You could do something like the following. Just replace the hardcoded address with {clipboard}.

{address="123 Main Street, USA"; trim=right}

Original Address
{=address}

Modified Address
{=replace(address, ",", ",\n")}


#3

Great! Works like a charm. Thank you so much :grinning: