RegEx help

[bsanders2009]

I am still a fairly basic Regex user but appreciate the power it brings to data parsing.  I'm stuck on parsing a pipe delineated series of numbers to return the first three results that start with a non-zero number.

For example, I have:

0|0|7|0|1|0|0|3|5|7|1|3
1|0|6|5|1|0|0|7|1|2|0|5

0|0|0|3|0|6|0|3|3|3|6|3

I want the following:

Value1	Value2	Value3
7	0	1
1	0	6
3	0	6

Any help would be greatly appreciated!

EDIT:  Note that my example above happened to have all single-digit numbers, but numbers between pipes can be double digit as well.

[Felipe_Ribeir0 · Accepted solution]

Hi @bsanders2009 

If i got the right understanding about the problem, the attached workflow will do the job.

INPUT:

OUTPUT:

[DanielG]

@bsanders2009  - i did one here without Regex, but using the Text to Columns within the Parsing Tool selections.

 Slightly different than @Felipe_Ribeir0 but they both give you some options.  That's the great thing about Alteryx there's 100 ways to do the same thing.  :)

[PhilipMannering]

Here's the Regex approach,

However the two approaches above are better.

Regex

P

[bsanders2009]

Love this community.  Thanks everyone!  I learned a lot from the different solutions today.  Much appreciated!