import txt or csv delimited parts into different excel sheets

Hi, tuspilica
The text file has 400.000 lines. Are you gonna extract all to one workbook (with many sheets)?
How many data parts is it? 1.000? 10.000?
In your sample each data parts has 5 lines (exclude the % and %%), is that always the case?
Can you attach some of the data? (unless it’s sensitive data). I need it to see the ‘variations’ & the ‘pattern’ of the data.

Hi Akuini,

i've attached a sample of the txt file.
The usual size is about 18Mb, i can't upload it here because of it's size, i can share somewhere else.

The file.txt contains about 50 sections (data parts), but i'm more particulary interested in about 25 of them.
At least 2 sections contains exactly 5002 rows. These data parts contains different kind of data, as number of rows, columns, ...
I'm not really interested to extract these sections only into one single workbook, with many sheets. It could be 2 or more with more sheets. But i prefer only one excel file, if possible.

In between %...%%% sections, it could be any other data rows unframmed by %...%%%, which i'm not interested in.

What can you say about the sample text attached?

Many thanks

Try this macro (backup your data first). Use sample data first. It worked on your sample.
You have to change the path in code line:

Please Login or Register  to view this content.

With 400.000 lines, I don’t know how long it will take, maybe 5 to 10 minutes? Please let me know how long when you’re done.

Please Login or Register  to view this content.

Thank you for your time and help Akuini!

Sorry for the inconvinient with crosspost. Itțs completely my fault, i should have read the instructions before posting.

I run the macro file that you sent to me; the major inconvinient is that it creates me 170 sheets, which is too much.
I only need just 25 sections from this data file.

I attached the excel with the 25 sections of interest.

If it's not too late, i would really apreciate your help.

Actually there's some inconsistencies regarding what character separate the sections. I thougt it was:
%%%
%
as your sample show in post 1.
But actually it sometimes just % or just %%%. So my macro won't work.
I'll modify my macro. I'll get back later.

Many thanks Jindon,

i tried your macro, it works fine, but the major issue is that it extracts all 170 sections into 170 sheets which is really, really hard for me to follow.

I'm more interested in only 25 sections from the .txt file.
Do you think it's possible to edit you macro to run just for a few Table sections?
If necessary i'll modify later the remain sections.
I attached here above a list with all 25 tables of interest.

Try this

You must have all the list in Sheet1 col.A
All the invalid characters for sheet name will be replaced with "_" underscore.

Please Login or Register  to view this content.

maybe i'm doing something wrong, after i run the macro, nothing happens.
i run the macro, it asks me to open the file, i navigate where the txt file is located, i select it, waiting and nothing.
it's not about macro security, because i deactivate the protection.

i'm at the office now, but i'll try later from my personal computer. keep you updated

Changed a bit

Please Login or Register  to view this content.

Thank you my friend. It works really fine!
I owe you big time.

I'll play a little bit with it to add some buttons and if possible to remove the % to do some "beautification"