Data Separator and Escape Sign
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,
Chandran Ganesan replied
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.
Press F1 after placing the cursor in these fields to see more info.