REGEX for multiple outputs

[jake8281]

I have sample data I am trying to have the first 5 digits in a reg 1(12345) and  in reg 2 I am trying to have (12345-123456). But I get Blank in Reg 1 and I get the values for reg 2.

How can I have the 2 columns together can someone fix my expression 

Spoiler

[ChrisTX]

If the string doesn't vary in length, just use the LEFT function    String Functions (alteryx.com)

Chris

[flying008 · Accepted solution]

Hi, @jake8281 

Try this:

((\d{5})-\d+)

[k0pik0]

set the first parse to (\d{5})

[jake8281]

@flying008 It worked! Can you give me breakdown how you made it work or what I did wrong in my expression 

[flying008]

Hi, @jake8281 

The greedy mode is advanced with 'or' expression in regex default option, so you can try again: (\d{5}-\d+)|(\d{5})

[jake8281]

@flying008 The greedy mode helped me out alot. Thank you so marked groups within marked group will have columns for smaller group and the bigger group at the same time