April 24, 2009 at 6:39 am
What is the use of text qualifier in flat file source
April 28, 2009 at 4:31 am
it is so you can include characters in the text which would normally cause problems, i.e. in a csv you can't include a , in a field - but if you use the text qualifier (normally " but can be anything) - any text between the two "'s is allowed:
To save this in a csv: Hello, My Name is...
would result with: Hello, My Name Name is... - which is two fields
using a text qualifier : "Hello, My Name is..." - is just one field
Ed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy