Handling delmiters coming with quote in sequential file

g_rkrish · Post by **g_rkrish** » Tue Apr 28, 2015 7:05 am

Hi,

I have an issue in reading the file which comes with

A"|"B"|"C

"|"as delimter it has the quote on it, long time on files so need ur help on handling it.

Tried using ""|"" did not work.

Thanks,
RK

chulett · Post by **chulett** » Tue Apr 28, 2015 7:32 am

Now we wait and see if "ur" shows up to help...

g_rkrish · Post by **g_rkrish** » Tue Apr 28, 2015 8:17 am

Sorry if my context was not good.I meant all the mebers in the forum to help me out..

chulett · Post by **chulett** » Tue Apr 28, 2015 9:21 am

A pet peeve. You're not chatting with your buds or tweeting so there's no reason to spell "your" like that on a (semi) professional peer-to-peer support site.

Did you try setting the field's delimiter string property to that? Without the extra quotes you have in your post? I would imagine you'd also need to ensure that quotes in general were set to none. If you do that and it still doesn't work, document here what happens.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 28, 2015 3:26 pm

Note that delimiter and delimiter string are different properties. The delimiter property is limited to a single character, the delimiter string property is not.

So, to reiterate what Craig advised, try setting the delimiter string property to "|".