Page 1 of 1

Handling delmiters coming with quote in sequential file

Posted: Tue Apr 28, 2015 7:05 am
by g_rkrish
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

Posted: Tue Apr 28, 2015 7:32 am
by chulett
Now we wait and see if "ur" shows up to help...

Posted: Tue Apr 28, 2015 8:17 am
by g_rkrish
Sorry if my context was not good.I meant all the mebers in the forum to help me out..

Posted: Tue Apr 28, 2015 9:21 am
by chulett
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.

Posted: Tue Apr 28, 2015 3:26 pm
by ray.wurlod
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 "|".