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.

Parsing String

NexBK
7 - Meteor

Hello, everyone.
I need help in splitting the string.

 

- Split into A and B in Field1
- Extract only "numbers", "." and "+" on the far right of Field1

NexBK_0-1665649869259.png

 

Thank you for your help.

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

Hey @NexBK, how do you get on with the following? It takes everything up until the last letter in the first group, before taking the rest in the second group:

 

(.+[a-z])(.+)

 

DataNath_0-1665650598431.png

Emmanuel_G
13 - Pulsar

@NexBK 

 

Find in attachement another way of doing that.

 

Emmanuel_G_0-1665667014708.png

 

binuacs
21 - Polaris

@NexBK One way of doing this

binuacs_0-1665700663357.png

 

Labels
Top Solution Authors