Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

VB.Net - Combine two text files into one with matching first column

Avatar of PNRT
PNRT asked on
.NET ProgrammingVisual Basic.NET
6 Comments1 Solution1410 ViewsLast Modified:
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.