Retrieve txtfile with different header position

Hello everyone,

I need help! I have over 50 CSV files extracted from SAP. The column names are fixed, but the header column positions start on different lines. The first file header starts with line 12, other starts with line 14, and so on.

Need help to retrieve the 50 csv file and consolidate into 1 file.

Thank you in advance.

Developer

Developer Tools

Accepted answers

kathbanc

Hello! thank you replying!

These are the sample file.

as you can see, the first file start with line 12

and the other file starts with line 13

Since they have different line number , i am getting this error :

ZT_1.txt

ZT_3.txt

caltang

The key is with the configurations of your input:

Of course, the rest is up to you to play with. I just did it in a way so your start point is easier to play with.

Sample for Kath.yxzp

All comments

caltang

Load some sample data and we can help. No need for the whole dataset, just some sample from your own end, like 3 files. I can show how after.

kathbanc

Hello! thank you replying!

These are the sample file.

as you can see, the first file start with line 12

and the other file starts with line 13

Since they have different line number , i am getting this error :

ZT_1.txt

ZT_3.txt

caltang

The key is with the configurations of your input:

Of course, the rest is up to you to play with. I just did it in a way so your start point is easier to play with.

Sample for Kath.yxzp

kathbanc

Thank you for your suggestion @caltang , was able to parse the column using the field 1

but i got new problem, multiple text files where the same column (like "Shipping") appears in different positions across files (e.g., 3rd column in one file, 5th column in another). Resulting in incorrect data alignment

caltang

You’ll need to make a macro for that then! Align one file then make it a batch macro. Feed the txt file paths and it’ll align accordingly.

if you are stuck, show me how the data should look like and I can make something.

kathbanc

Hello! I try to search for macro , but it does not work for me T_T

the alignment of column start with SAP carrie

ZV14_v2.txt

ZV14_v1.txt

caltang

I don't get it @kathbanc

From ZV14_v1.txt, show me how it should look in Excel. Do it once manually with each column name and its respective value, then we can help better.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703