SOLVED How to find a carriage return suing REPLACE_PATTERN

rocketman

It's the small things that get me, and I should know this but how do you find a carriage return in a string so you can use REPLACE_PATTERN to convert it to something like a comma and a space. I'm used to looking for ascii codes like CHAR(13) but these don't seem to work.

TIA

joben

Have you tried looking for the \r or \n character?

User Guide PDF --> Appendix E. Regular Expressions.
https://www.awareim.com/documentation/

BobK

I use the CR function.
https://www.awareim.com/dokuwiki/doku.php/a_f/f/af/cr

REPLACE_PATTERN(BO.TextField, CR(), ', ')

rocketman

Thanks to @[deleted] and @[deleted]

Both these actually worked but the problem was - not in a word document as part of the mail-merge. It kept throwing an error "Invalid Tag Expression" The mail-merge I was trying to do had the code <<REPLACE_PATTERN( BO.address, CR(),', ')>> (actually trying to fit an address containing 5 single elements into a space designed for someone to write into (a membership application form)

I ended up getting round it by creating a non persistent bo just before the call to do the merge NPBO.addresstext=REPLACE_PATTERN( BO.address, CR(),', '), then putting a simple <<BO.addresstext>> into the word doc.

Thanks again guys