Hi,
When i am copying CSV data in txt it is giving me extra comma at the end,
how can i overcome this issue coz my csv has more than 500 rows and removing unnecessary comma from txt is difficult.
CSV_Image.jpgCSV_Image.jpg
In Txt it is showing like as attached.
TXT_Image.jpg
Please see both attachments and help.
Thanks a lot in advance.
Regards
Ishan A
Difficult to say without seeing the file. However, you don't have an "extra" comma after the last field. You have a comma before the last blank ( ? ) cell where a row only has data in four columns.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks