I have like 90,000 records which have the name, specifications, price and UOM fields.
I have all these in a tab delimited file downloaded from a company where the records are entered manually in their format into their db.
Now, few of these records have the fields rolled to the next line, which is causing problem to the prog I have to create based on this file. I could understand that it is because of the file from the company which has errors, ie, they hit enter, due to which it goes to the next line, causing problems to my prog.
So I would like to know how we can write a code which would delete the carriage return by checking each and every record, if it has any.