Check csv file for number or fields in each record and filter out
Posted on 2008-02-09
I have been given a txt file with users names and addresses. My problem is I imported it into excel and went into the first column with a good record having 4 lines followed by a blank line I got around that by exporting it to a csv file and tnen using multiline to export it to a record with 4 fields that went into Columns a,b,c,d.
Now I found out that some of the records don't have 4 lines but 3 lines. Is there anyway to add a line or sort out the 3 line records? There is about 20000 lines in the spreadsheet so it is quite large and I want to automate this.
Name, Address1, Address2, City Zip.
some of the records have only 3 lines in them eg Name, Address1, City Zip.
What is the easiest way to either sort the 3 line records or fix the records with only 3 lines.
here is an example of the file
4230 HARDING PIKE
NASHVILLE TN 37205
300 BOMAR HEIGHTS
AARON MED CNTR
COLUMBIA KY 42728
2105 EDWARD CURD LANE
FRANKLIN TN 37067