Data Separator and Escape Sign

[Former Member]

Hello Friends,

while doing flatfile extraction we have the options of Data Separator and Escape Sign,can anyone tell whats the role of these two functions? How does it affect the dataload?

Thanks in advance,

Chandu.

[ChandranGanesan · Accepted solution]

Hello,

The data seprator will help the system to identify each field in a record. Example ( , - Comma) in a CSV file will help to seperate each field in a row (Record).

If the separator that you specified under Data Separator is a part of the value, the file indicates this by enclosing the value in particular start and end characters. Enter these start and end characters under Escape Characters.

Also

Press F1 after placing the cursor in these fields to see more info.

Thanks

Chandran

[Former Member]

Good day

1) Maybe the following information wll help?. This is the information form F1 function on the field:

"For the fields

- Separator and

- Escape character

enter either a letter, a number of a special character

If you wish to enter such special characters as a tabulator or linefeed

or are not sure whether a semi-colon from Excel, for example, should be

interpreted as such then you can enter the special character in

hexadecimal code.

This will be used unfiltered for the upload.

The letters, numbers or special characters are then changed to a

hexadecimal number internally.

Letters, numbers or special characters must be in the entry field in th

first instance.

In each case enter just 1 character in each entry field.

As soon as two characters are in the entry field an attempt will be mad

to interpret these as hexadecimal numbers.

If the Hex field is checked off, the contents of the fields Data

separator and Escape characters are always given as a hexadecimal

number. Letters and characters are also outputted with their internal

hexadecimal code after the entry with a further PBO-PAI. """"

2) The following file (.CSV) was opened in Notepad, see the ',' and ' " '

"700053","Mercedes-Benz Sandton","Service (70)", 61059 ,"Mercedes-Benz Passenger","Mercedes-Benz A200 5 DOOR","Miss J Cart","DXXXXXGP","20071123", 194 ,"20080604"

"700053","Mercedes-Benz Sandton","Service (70)", 23526 ,"Mercedes-Benz Passenger","SL65 AMG,PANORAMIC ROOF","Mr Segev","WXXXX9GP","20080411", 54 ,"20080604"

"700053","

If the data seperator is ',' and escape sign is ", in .csv file, then data from file will be loaded correctly.

Hope this helps

Cj