Problem with TextToColumns parsing comma, overwriting column

[ebrary_steve]

I have numerous TXT files I want to merge into one workbook. Each TXT is tab-del, 42 columns wide and needs to be formatted as text. I have a script to perform this function but I run into a problem.

The problem is that whenever a comma is parsed every subsequent field in that row is overwritten to the cell after where the comma was found and the rest of the text in the field where the comma was found is removed.

For example, given the following (assume here the four space characters are each tabs)...

Field 1 Field 2 Field 3, some text Field 4 <Field 5 is null>

...Field 1 and 2 are correct but Field 3 only contains "Field 3" (no comma, no subsequent text). The next field in the row is blank. I'm assuming its data was overwritten by the null data in field 5. This is quite problematic for me as the data I'm parsing contains a lot of literal text with punctuation.

Can someone please take a look at the attached workbook and be able to tell me what I'm doing wrong here?