I have received CSV file with one column & each row have one records with several fields in it. Each row have name, Address & comments and each filed broken into line feed and carriage return ("OD" and "OA"). I am using Visual FoxPro to open this file in Excel and copy each filed into separate column. Do the same thing for entire file.
Example one column:
Row-1
Mr A B sample
Dear Mr Sample
Sample Street
Sample Road
Credit balance
Row-2
Mr x y Bond
Dear Mr Bond
Sample Street
Sample Road
Sample Suburb
No Balance
No Pay
I need to copy each field into separate column, so that I can import that into VFP table.
Some reason my logic is not working. Please help, if any one has any idea how to do this.
Thanks
Example one column:
Row-1
Mr A B sample
Dear Mr Sample
Sample Street
Sample Road
Credit balance
Row-2
Mr x y Bond
Dear Mr Bond
Sample Street
Sample Road
Sample Suburb
No Balance
No Pay
I need to copy each field into separate column, so that I can import that into VFP table.
Some reason my logic is not working. Please help, if any one has any idea how to do this.
Thanks