Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Use one Regex tool to split String with various spaces

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:

310035272898!!CL UNGARISCHE SALA52Wurst8201010-Nov-20698862 06:59:2207:14:0807: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

22 REPLIES 22
atcodedog05
22 - Nova
22 - Nova

Hi @Alexander_Gruber_FhA 

 

Fixed it

atcodedog05_0-1605724956296.png

Please check and let me know 

Works perfect @atcodedog05. Again thank you for the great and quick support!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Alexander_Gruber_FhA 

 

Cheers and Happy Analyzing 😀

 

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

Labels
Top Solution Authors