Parsing after a word

Hi,

I'm trying to use the RegEx function to parse the data after the word 'DIS T' so that I can then use the space delimiter to break this down into separate columns.

Could someone please help me with this? I have tried 20 odd functions but I'm unable to figure this out.

Thanks!

Regex

Parse

Accepted answers

DavidP

I'll break it down from left to right:

some stuff: .+

followed by: DIS T

followed by a space or more: \s+

followed by a set that consists of numbers and/or dots and/or minuses: ([\d\.-]+)

followed by a space or more: \s+

followed by a set that consists of numbers and/or dots and/or minuses: ([\d\.-]+)

followed by a space or more: \s+

followed by a set that consists of numbers and/or dots and/or minuses: ([\d\.-]+)

The 3 sets of () define the 3 columns you're looking to parse the data to.

Hope this makes sense.

All comments

DavidP

How about this in Regex parse mode

.+DIS T\s+(.+)\s+(.+)\s+(.+)

NikitaShetty

Hi David,

That works partially, the first set of digits (30.00) gets tagged to the 8.99- in the same column and then I get the last set separately (20.99):

How can I tweak the expression to get the middle '8.99-' in the separate column?

Thanks!

DavidP

Try this

.+DIS T\s+([\d\.-]+)\s+([\d\.-]+)\s+([\d\.-]+)

regex parse numbers.yxmd

NikitaShetty

Hi David,

Thanks a mil - This works like a charm!

Could you just let me know what the expression actually translates too? It might help me to figure out solutions in the future!

DavidP

I'll break it down from left to right:

some stuff: .+

followed by: DIS T

followed by a space or more: \s+

followed by a set that consists of numbers and/or dots and/or minuses: ([\d\.-]+)

followed by a space or more: \s+

followed by a set that consists of numbers and/or dots and/or minuses: ([\d\.-]+)

followed by a space or more: \s+

followed by a set that consists of numbers and/or dots and/or minuses: ([\d\.-]+)

The 3 sets of () define the 3 columns you're looking to parse the data to.

Hope this makes sense.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703