Page 2 of 2
Posted: Wed Dec 27, 2006 1:24 pm
by johnthomas
change the field delimeiter as the pipe symbol , and quote as double confirm whether the settinga are as above
Posted: Wed Dec 27, 2006 1:34 pm
by I_Server_Whale
DSguru2B wrote:Ok the input file looks really suspicious. Your quote character surrounds the delimiter and not the values.
Absolutely! Let's see what the OP has to say about it.
Posted: Wed Dec 27, 2006 2:17 pm
by ady
Did what u said , Most of the data had "" around them , but they were few fields where the "" were missing..... Hmmm..... thats when I figured out that one of the data I am using has 4 fields more than the other !!
The original source data was messed up , I have changed it and now it works well.
Posted: Wed Dec 27, 2006 2:18 pm
by ady
Resolved ! ... thnx a ton ppl
Posted: Wed Dec 27, 2006 2:20 pm
by DSguru2B
Remember, it takes only one misplaced/missing quote to trigger it all.