Good morning,
I received an MS Excel (XLS) file and the cells contain text similar to this one:
and I would like all \n to be converted into placeholders. I do not need a new line after.
Can someone suggest a Regex pattern to convert the \n into placeholders?
I made some attempts in Excel File Type (Embedded content - Enable embedded content processing) but I couldn't find the solution.
Thanks for your help.
Fabio
Try \\n as you need to escape the backslash as it has a special meaning in regex.
If you still have a problem you better tell us how you are setting this up and preferably provide screenshots.
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Try \\n as you need to escape the backslash as it has a special meaning in regex.
If you still have a problem you better tell us how you are setting this up and preferably provide screenshots.
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Translate
