question Re: 'ReplaceText" processor does not replace special characters as a "Replacement Value" in Support Questions

'ReplaceText" processor does not replace special characters as a "Replacement Value"

rbalakrishnantc — Thu, 10 Nov 2016 18:33:57 GMT

I have a 'Control A' separated file. I am trying to append each line with a date value with the regular expression,

${srcdelim}${now():format('mm-dd-yy')}

where ${srcdelim} contains the value '\u0001' from a schema file.

Apparently, the output file contains the string \u0001 rather than a control A delimiter.

I have attached my sample input and output.

Character Set: UTF-8

Re: 'ReplaceText" processor does not replace special characters as a "Replacement Value"

gkeys — Thu, 10 Nov 2016 21:42:45 GMT

Could you include a sample of two records? Please update your question with the sample.

Re: 'ReplaceText" processor does not replace special characters as a "Replacement Value"

TimothySpann — Fri, 11 Nov 2016 01:05:54 GMT

is this UTF-8?

Re: 'ReplaceText" processor does not replace special characters as a "Replacement Value"

arunak — Sat, 12 Nov 2016 00:43:41 GMT

Rather than using \u0001 can you try \cA for the control A character? Reference : http://www.regular-expressions.info/nonprint.html "Many regex flavors also support the tokens \cA through \cZ to insert ASCII control characters. The letter after the backslash is always a lowercase c. The second letter is an uppercase letter A through Z, to indicate Control+A through Control+Z. These are equivalent to \x01 through \x1A (26 decimal). E.g. \cM matches a carriage return, just like \r, \x0D, and \u000D. Most flavors allow the second letter to be lowercase, with no difference in meaning. Only Java requires the A to Z to be uppercase."

Re: 'ReplaceText" processor does not replace special characters as a "Replacement Value"

gkeys — Sun, 18 Aug 2019 10:39:27 GMT

@bala krishnan

It works for me when I set Replacement Strategy to "Literal Replace":

my input file has control-a (but no \001) and my output file has control-a followed by test.

When I use the default Replacement Value ("Regex Replace") my output file has \001test