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

Beginner Asked on March 5, 2020 in Diyotta Studio.
Add Comment
1 Answer(s)
-> 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 (“).
-> 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
Expert Answered on March 10, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.