Hi all, I have a problem where I have a csv file that has data separated by semi-colons. Easy to import into excel or access and split you may think. However, my data is formatted as follows:-
0100 Resident;Resident2 Title;Title2
Where the spaces (TAB) is the column delimiter and ; is the delimiter within the next column. Finding it difficult to explain but I have a line where the first column contains the reference number for that property, but then the second column contains TWO Names split by the semi-colon, the third column contains those people's Title's and so on. There are always the same amount of entries in the remaining columns as in the second column, so every resident will have a title etc, however the FIRST column only has the ONE reference number entry!!
I want to split/view the data so this it would read as follows:-
0100 Resident Title
0100 Resident2 Title2
Hope this makes sense! And hope it's possible! Have attached sample CSV file.
I'm no programmer but am pretty good with excel/access if someone could point me in the right direction!