Simple character substitution??

[Doug Bilton]

There has got to be a very easy way to do this.... In a Data Transformer, we have a series of String Manipulation FCVs. We want to remove occurrences of !@z with a single newline. How do we indicate a single newline? Any special characters we need? (If we just do a newline in the replace with box, we see two newlines in the doc.) We have tried things like \n and '\n'. Since this is in a block of text with multiple paragraphs and spacing lines, we can't use ignore newlines to get rid of the extra newline.

 

[MailGuru]

Hi Doug,

Not sure what you are trying to accomplish, or, what language you are doing this in (SQL? maybe) in most languages a "new line" is usually the result of two ASCII codes: CR (carriage return) + LF(line feed) CR+LF - ascii decimal char(10)+ascii decimal char(13).

In the command that you are using, I'm assuming "\n" is generating those two ascii characters. If you are trying to just remove !@z and make the line end there, is there a different command for just "Carriage Return" (without the Line Feed), or maybe even "VT" (Vertical Tab)?

My suggestion might not help any since I'm not familiar with the commands you are using, if not, sorry about that.

-Best

MailGuru