Hi Experts. I have two comma delimited text files. One with four columns and one with two columns. All values are strings. The first column of each file is an ID string common to both but not necessarily in the same order. They both have the same number of rows and they shouldnt be any blanks in the files.
I need to take the second column of the file with two columns into the file with four columns, making five columns. The data in each file must correspond with the ID number of the first columns in both files.
It would be good to have the data in a third file if thats OK
I hope this makes sense
Any help with the code on this would be greatly appreciated.