Trouble viewing source data

johnthomas · Post by **johnthomas** » Wed Dec 27, 2006 1:24 pm

change the field delimeiter as the pipe symbol , and quote as double confirm whether the settinga are as above

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 1:34 pm

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.

ady · Post by **ady** » Wed Dec 27, 2006 2:17 pm

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.

ady · Post by **ady** » Wed Dec 27, 2006 2:18 pm

Resolved ! ... thnx a ton ppl

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 2:20 pm

Remember, it takes only one misplaced/missing quote to trigger it all.