Reading a csv file

You need to manually join the strings at index 2 and index 3.

string employeeOrgna = string[2] + " " + string[3];

then write it back to a new csv file. Its a programatic error that is based on the fact that when you are using the Split function for the string, its delimiting of every single "," as you have found out. The way to fix it is to realise that the number of columns in the particular csv file should be fixed to a constant value. This way you can use a constant index and join the two together.

An alternative (if the number of columns is going to change) is to use RegularExpressions and look into the "Groups" function for RegEx's. This way you can use a clever mechanism to split at certain locations in each line of the csv.

Dave