Use one Regex tool to split String with various spaces

[Alexander_Gruber_FhA]

Dear all,

i would like to split a string according the following table. The required informations are seperated with a different amount of spaces. Within the arcticle describtion (target column number 3) the amount of words can be differ also from row to row.

Inital situation:

\par 310035 272898 !!CL UNGARISCHE SALA 5 2 Wurst 082010 10-NOV-20 698862 06:59:22 07:14:08 07:00:15

Target:

310035

272898

!!CL UNGARISCHE SALA

5

2

Wurst

82010

10-Nov-20

698862

06:59:22

07:14:08

07:00:15

Is it possible just to split this string with one regex tool, or do I need more tools? I would appreciate your support.

Thanks in advance,

Alex

[atcodedog05]

Hi @Alexander_Gruber_FhA 

Please find the updated workflow adjusted to the scenario.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Alexander_Gruber_FhA]

Hi atcodedog05,

thanks for the quick response.

There is still the problem in column "RegExOut7". The regex is not splitting the number and the date in two seperate columns.

Br,

Alex

[atcodedog05 · Accepted solution]

Hi @Alexander_Gruber_FhA 

Fixed it.

Hope this is right now 🙂

[Alexander_Gruber_FhA]

Thanks, works perfect!

Br,

Alex

[atcodedog05]

Happy to help 🙂 @Alexander_Gruber_FhA 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂

[Alexander_Gruber_FhA]

Hi @atcodedog05  again,

please believe me, that I´m very sorry that i have to ask again.

But with the regex function there is another problem:

\par●003135●●●882279●!!CL●UNGARISCHE●SALA●●●●●●●●●●5●2●●●Wurst●●●●●●082010●10-NOV-20●●●●●●●●●●●●698862●●●●●06:59:22●07:14:08●07:00:15

\par●G13135●●●882279●!!CL●UNGARISCHE●SALA●●●●●●●●●●5●2●●●Wurst●●●●●●082010●10-NOV-20●●●●●●●●●●●●698862●●●●●06:59:22●07:14:08●07:00:15

It is possible that information 2 starts with a letter (green colour) instead of a number. In this case the regex function did not work.

May you please support again. Thank you very much!

Alex

[atcodedog05]

Hi @Alexander_Gruber_FhA 

Here is the updated workflow

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[seven]

@PhilipMannering 

why use two tools? Regex and Formula?

Why not use one tool? Instead of using a Tokenize operation, use a replace operation. Regex_replace

\S+

with ' '.

[PhilipMannering]

@seven If you show me a workflow where that works, then I'll agree with you!

[Alexander_Gruber_FhA]

Hi @atcodedog05,

still two problems:

1.)

Initual situation:

\par 003135 704780 CL LANDJAeGER 200 G 1 2 Wurst 082021 10-NOV-20 698862 06:59:22 07:14:08 07:00:27

After regax:

LANDJAeGER

200

G

1

2

Wurst

082021

10-NOV-20

698862

06:59:22

07:14:08

07:00:27

I´m not quiet sure why this happens, when the strings looks like the example from the initual situation?

2.)

\par 004060 779349 BILLA KAKAOMILCH 250 10 1 Obst - FD 026045 10-NOV-20 777094 20:25:53 21:35:33 21:00:52

If information 4 contains of 2 numbers (green colour), regex didn´t work.

Thanks for your support,

Alex