What is the use of Text Qualifier property and how it work?
In my table some of data having double quotes and special characters then how can i load data into target table without fail
-> A text qualifier is a symbol that let’s file know where field/text begins and ends.
-> If a field contains the delimiter character within its text, the program interprets this as the end of the field rather than as part of the text. In order to prevent this, it must have a qualifier. The qualifier is placed around each field to signify that it is the same field. The most common qualifier is double quotes (“).
-> If a field contains the delimiter character within its text, the program interprets this as the end of the field rather than as part of the text. In order to prevent this, it must have a qualifier. The qualifier is placed around each field to signify that it is the same field. The most common qualifier is double quotes (“).
-> Use Text Qualifier as SINGLE(‘) to prevent conflict. It will place single quotes around each field.
-> Else if Text Qualifier as DOUBLE(“) is used and specify Escape Character as (\”). It will place double quotes around each field and escape double quotes which are present in the data
-> Else if Text Qualifier as DOUBLE(“) is used and specify Escape Character as (\”). It will place double quotes around each field and escape double quotes which are present in the data