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