Need help on a Parse Regex

[Yanopoff14]

Hello the community,

I have some troubles on a Parse Regex for a txt file. This file is a products info list and I just want to extract some columns.

- Example (or see the image or file "Data set") :

- What I am looking for is underlined (this is just 1 line):

18495746201812PROBIOTICA DARMBALANS CAPS STRIP 30ST 200910 C01A 8711744029548 15527557ONBEKEND CAPSULE 000000000000N.V.T. STRIP 00003000STUK 00001500STUK VEMEDIA# SNEDERLAND 000000000022PS

- What I want as output is:

RegEx out 1	RegEx out 2	RegEx out 3	RegEx out 4	RegEx out 5	RegEx out 6	RegEx out 7	RegEx out 8	RegEx out 9	RegEx out 10	RegEx out 11
18495746	201812	PROBIOTICA	CAPS STRIP 30ST	VEMEDIA#	S	NEDERLAND	0000000000	2	2	PS

I succeeded to parse the first three parts with this expression (\d+)(\d{6})(\u*) and I get blocked to continue and to extract the rest.

(see my attached workflow "Test regex").

Can anyone help me please? Should I continue with RegEx or maybe is there another tool which could do the trick?

Yanopoff

[DavidP]

This gets you a bit closer - just have to figure out a rule for CAPS STRIP 30ST

(\d+)(\d{6})(\u*).+\s(.+)\s(\w)(\w+)\s(\d{10})(\d)(\d)(\w{2})

[Ladarthure · Accepted solution]

Hi,

why don't you use an input with a flat ascii file format to get the data you want, it seems to me that your data set.txt would be perfect to do so!

[DavidP]

I like @Ladarthure 's idea, but I've not given up on regex...

Granted, I've made a few assumptions that you might have to tweak, but here you go:

(\d+)(\d{6})(\u*)\s\w+\s(.+)\s\d{6}\s.+\s(.+)\s(\w)(\w+)\s(\d{10})(\d)(\d)(\w{2})

[carlosteixeira]

Hello @Yanopoff14 maybe this help!

best regards..

Thanks

[Yanopoff14]

Hi @DavidP , @Ladarthure  and @carlosteixeira ,

So great to have some help.

Thanks DavidP and carlosteixeira2005 for your regex. It took some time to try DavidP and carlosteixeira2005 solutions. Both were great and I learned a lot. However, it looks like the Regex cannot work for my file. From what I understand, it is because some products do not have all the columns filled (missing or nonexistent data). I tried modify them with the website regex101 but I failed!

I also tried Ladarthur solution. It worked just fine and you are right, it fit perfectly my file. Thanks a lot, I did not know about that extension and the way it works.

Thanks again everyone for your fast reply ;^)

Yanopoff