Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Split a string field into two fields using RegEx / Text To Columns ?

pk1
7 - Meteor

Hi All,

 

I want to split a column/field into 2 fields, First i removed " -" from all fields and used RegEx Expression: " (\<\w+\>)(.)(\d+) "  &  "(.*)\s(.*?\>)" in RegEx , both did not work for me. 

 

Input Field

SERA-14

MERA-SERA-15A

PET-YB-64B

PET-XB-64B

RB&L-13

CCP-14, CCP-16

 

Output Field 1         Output Field 2 

SERA                           14

MERA SERA               15A

PET YB                       64B

PET XB                       64B

RB&L                           13

CCP                             14

CCP                             16

 

Can anyone please help me out to solve this issue

Thanks in advance 

3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

Try the attached.

 

First regex without changing the -:

(.*)-([^-]+)

Then correct the -

MSalvage
11 - Bolide

@pk1,

 

@jdunkerley79's solution should work unless that last data point really does contain "CCP-14, CCP-16". If so you will want to use the text to columns tool first, set to split to rows with ", "(comma space) as the delimiter and selecting skip empty fields.

pk1 text to rows.PNG

 

Best,

MSalvage

pk1
7 - Meteor

Thanks for your help, Expression worked. But in input (CCP-14, CCP-16) is a single row, So first i have to split it into 2 rows and then apply Regex formula

Labels