Help with Regex Parse

Hi all,

I'm trying to separate the data using regex parse.

Column1

1. ASdfgtchbn123ADFGV8,/djvvjlvi69
2. XDfctyubjn1546

Some part of the data in the input is same in the two records. But, other part in first record is little different. I tried multiple approaches.

I used the below pattern.

([A-Z][a-z]+)(\d+)|([A-Z]+)(\d),/([a-z]+)(\d+)

When I use above pattern then I get the output as above.

If I use the pattern like this ([A-Z][a-z]+)(\d+)([A-Z]+)(\d),/([a-z]+)(\d+) then I get the below output.

How do I get the output data in the two records without disturbing any?

Please help.

Thank you.

Best regards,

teja.

New Workflow3.yxmd

Workflow

Regex

Parse

Accepted answers

philipmannering

@stj1120

This works for your two records (and probably your two records alone)

([A-Z][a-z]+)(\d+)(?:([A-Z]+)(\d),/([a-z]+)(\d+))?

Note that your examples start with two upper case latters and your expression matches only one: so the output will change when you untick the Case Insensitive.checkbox.

All comments

gabrielvilella

You are missing a backslash before the forward slash.

([A-Za-z]+)(\d+)|([A-Z]+)(\d),\/([a-z]+)(\d+)

philipmannering

@gabrielvilella You don't need to escape a forward slash.

philipmannering

@stj1120

This works for your two records (and probably your two records alone)

([A-Z][a-z]+)(\d+)(?:([A-Z]+)(\d),/([a-z]+)(\d+))?

Note that your examples start with two upper case latters and your expression matches only one: so the output will change when you untick the Case Insensitive.checkbox.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703