If some columns may contain the separator, you can escape their content before writing them into the table, and unescape them after you split the row, before you use the content. You can use URL escape characters (e.g. http://www.werockyourweb.com/url-escape-characters) or something more reader-friendly (e.g. "|" -> "<pipe>").
Cheers, Gheorghe On Mon, Oct 17, 2011 at 9:37 PM, kiranprasad <[email protected]> wrote: > Hi > > How can I ignore the seperator character in middle of a column value. > > eg : Seperator char is ‘|’. > > The Record values are | seperated > > xyz|1234|98798|”xyz|abc”| > > > Regards > Kiran.G
