Escaping Strings

What is "Escaping strings"?

Escaping a string means to reduce ambiguity in quotes (and other characters) used in that string. For instance, when you're defining a string, you typically surround it in either double quotes or single quotes:

"Hello, World."

But what if the string had double quotes within it?

"Hello "World.""

Now we have ambiguity - the software doesn't know where my string ends. one solution is to use single quotes around the string:

'Hello "World."'

Or I can escape my quotes:

"Hello \"World.\""

Any quote that is preceded by a slash is escaped and understood to be part of the value of the string.

Character combinations consisting of a backslash (\) followed by a letter or by a combination of digits are called "escape sequences." To represent a newline character, single quotation mark, or certain other characters in a character constant, you must use escape sequences. An escape sequence is regarded as a single character and is therefore valid as a character constant.

Escape Sequences

Using escape Escape Sequences in Visual Importer

In Visual Importer we can use integrated language to correct the data:

begin
Result:=Replace(EscapeString(F001),'\n','');
end

Using Escape Sequences in Advanced ETL Processor

Here we can just escape string and replace the data

or we can use replace characters function