newline character does not work when using column values for replacement

Hi experts,

I try to use a configuration table for regex string parsing.

I use a column expression and use column.match for condition and regexReplace for string manipulation.

It works fine for matching, finding, and replacing the specific parts in the string.

However, when I try to insert a newline into replace string, it seems that the newline character (\r ) cannot be recognized by system and will only return “rn” as two escape characters.

Is there anything I forgot to change?

Thanks for your help! :slight_smile:

regexReplaceTest.knwf