May 28, 2014 at 1:12 pm
Hello Folks,
I am using Flat File Connection to process files into Database.
Files coming with text qualifier and delimited by comma.
But in some of the columns I am getting data which has text qualifier in it. and I am getting error becasue of it.
For Example. I have this data in one of the column.
"Viral E-card supporting "MESC" initiative Logo"
How to remove text qualifier from "MESC" and process data?
I want to process like "Viral E-card supporting MESC initiative Logo" or "Viral E-card supporting "MESC" initiative Logo" without error.
Any thoughts on this would be appreciated.
Thanks:-)
Viresh
--------------------------------------------------------------------------
“ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
— Sir Henri Deterding
May 28, 2014 at 1:18 pm
viresh29 (5/28/2014)
Hello Folks,I am using Flat File Connection to process files into Database.
Files coming with text qualifier and delimited by comma.
But in some of the columns I am getting data which has text qualifier in it. and I am getting error becasue of it.
For Example. I have this data in one of the column.
"Viral E-card supporting "MESC" initiative Logo"
How to remove text qualifier from "MESC" and process data?
I want to process like "Viral E-card supporting MESC initiative Logo" or "Viral E-card supporting "MESC" initiative Logo" without error.
Any thoughts on this would be appreciated.
According to the RFC 4180, which is the Common Format and MIME Type for CSV Files, a text delimiter within a field must be escaped by a text delimiter. Hence you need to add not remove delimiters.
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply