txt to csv conversion
Posted: Fri Sep 03, 2010 9:37 am
Hi ,
I am converting txt files to csv ..
I open txt file into excel 2007 , 'comma' is used as delimiter and save it as .csv.
When I open it into seq stage , I see verticle line at the end of last column , and square in the database .
I tried coping the file and pasting as special values by selecting column only ...but the same problem...
I used trim too in the last column ...
But still i see square in orace table..
please suggest ...
Am I converting txt properly....
Thanks in advance ...
I am converting txt files to csv ..
I open txt file into excel 2007 , 'comma' is used as delimiter and save it as .csv.
When I open it into seq stage , I see verticle line at the end of last column , and square in the database .
I tried coping the file and pasting as special values by selecting column only ...but the same problem...
I used trim too in the last column ...
But still i see square in orace table..
please suggest ...
Am I converting txt properly....
Thanks in advance ...