A lot of our users ask us how to deal with special characters. for example "End of the line" can be in the middle of notes fields and it has to be deleted or replaced. there are several ways of dealing with it

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
Escape SequenceRepresents
\a Bell (alert)
\b Backspace
\f Formfeed
\n Newline
\r Carriage return
\t Horizontal tab
\v Vertical tab
\' Single quotation mark
\" Double quotation mark
\\ Backslash
\? Literal question mark
\, Comma
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

Ecape1

or we can use replace characters function

Ecape2

Direct link, no registration required.
 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies