Parsing with regex

[dataminerchris]

Hello,

I am trying to parse some article numbers that have a similar structure, but I have forgotten the basics of regex groups. The string I wish to decompose is of the form "SUPR5 VALLEY OAK 997D NHMN 5000 ST28" (5 alphanumeric, space, some words of only letters, space, 4 alphanumeric, 4 letters, 4 digits, 4 alphanumeric)

I have tried the following "(\w+) (\D+) (\w4) (\D) (\d) (\w4) " with the intention of eliminating groups 4 and 6 in a later stage. I selected "Parse" from the "regex" parse tool. The columns all come out with NULL.

What are the basic mistakes i am making ?

Thanks for help.

[mot]

Hi @dataminerchris ,

You can try:

(.*) (.*) (.*) (.*) (.*) (.*) (.*)

I hope this helps. Best.

[mot · Accepted solution]

Hi @dataminerchris ,

Please see the attached workflow. Best.

[dataminerchris]

Hi there

thank you very much : it works great !

I guess I was trying to make it too complex...

all the best

[Qiu · Accepted solution]

@dataminerchris 

Thank you for giving clear definition.

[dataminerchris]

Hello Qiu,

thank you very much : this indeed captures the irregular structure of central words section (there are not always the same number of words !)

Great help.

have a nice rest of day

[Qiu]

@dataminerchris 

Glad to help and you too have a nice day!😁