Need to understand how to parse a .txt file

[swade730]

Hi All,

I have a .txt file that used text to columns in the vba code to split the data into columns.

The issue is that the data does not end up like in all the appropriate columns. For example lets say col a has names and col b has phone numbers.
I'd get a result whereby some of the phone numbers end up in col a (when they are supposed to end up in column b)
Can anyone provide insight into how they would approach this issue?

I don't have a sample.

[TMS]

Think you'd need to post a sample text file and maybe the Excel file you get. To use Text to Columns, you would need the file to be delimited in some way, perhaps by commas or tabs. Sounds like that might be the issue.

[Leith Ross]

Hello swade730,

How is the file delimited: Spaces, Commas, Tabs, or something else?

What do the phone numbers look like?

[swade730]

Think you'd need to post a sample text file and maybe the Excel file you get. To use Text to Columns, you would need the file to be delimited in some way, perhaps by commas or tabs. Sounds like that might be the issue.

The File is delimited, I believe by tabs. In the file itself , it's structured such that it includes different information exist under different people. I can't share the file, it's private.
But let me try to further explain.

Ultimately this data in the text file needs to end up in excel in particular columns.
So I can get the note pad data in column A. and then there is this code that looks for a word in col A like
.Find("Phone Numbers:") or ("Address") or ("Product")...
So for each one I just mentioned, once that word is found a parse(text to colums) happens. but at the end (once all the criteria is searched). The data ends up in the wrong column because perhaps one name did not have an address, or there was no phone number. it's strange



I can post that code in a another day or so as an example - it's on my other computer.

[swade730]

Hello swade730,

How is the file delimited: Spaces, Commas, Tabs, or something else?

What do the phone numbers look like?

Like the area code will end up in column C and the rest of the numbers in column D (When all should be in column C)

[TMS]

You have data (the text file), code, and a process that the code is meant to fulfil, none of which has been shared with us. You then describe what you think should happen and state that it doesn't happen under some conditions. All well and good when you can see the data and the output. But have limited imagination and I can't picture it.

Note: the code alone will not be enough. I suggest that you take a live example and edit it in NotePad to remove any sensitive information and remove the bulk of the data.

[swade730]

You have data (the text file), code, and a process that the code is meant to fulfil, none of which has been shared with us. You then describe what you think should happen and state that it doesn't happen under some conditions. All well and good when you can see the data and the output. But have limited imagination and I can't picture it.

Note: the code alone will not be enough. I suggest that you take a live example and edit it in NotePad to remove any sensitive information and remove the bulk of the data.

OK, will do...I understand how my explanation is confusing. -My apologies. I will try to clone and attach example that is more comprehensible.