RegEx - Tokenize

Hi,

Gradually getting familiar with the RegEx tool but not quite there yet. I have attached an excerpt of the data showing the input and the output that I want.

I used the following as a regex expression:

\u{2}\s\d.*\>\u{2}\s.*\-\s\(d.*) and then tokenize into rows

But got the Reg EX Mismatched brackets exception, not sure why though. Can someone pls help?

Many thanks

Sylvia

Reg Ex query.xlsx

Workflow

Tips and Tricks

Accepted answers

SylviaK

@Maskell_Rascal

Brilliant. It does work. Can you pls explain this expresison though? I get .*, but not the brackets and the bits in the bracket. many thanks

(?<=>).*

All comments

vizAlter

Hi @SylviaK — "(" is missing.

(\u{2}\s\d.*\>\u{2}\s.*\-\s\(d.*)

Are you using this?

ImadZidan

Hello @SylviaK ,

It is the digit back slash. it should be in the brackets

you have: \u{2}\s\d.*\>\u{2}\s.*\-\s\(d.*)

should have: \u{2}\s\d.*\>\u{2}\s.*\-\s(\d.*)

SylviaK

unfortunately, the output column is just blank, not how I wanted the output column to be (see previous attachment). Could there be something wrong with the expression?

Maskell_Rascal

Hi @SylviaK

I think this is what you're looking for. I'm not super well versed in RegEx, but was able to get to your desired output combining a couple different tools.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Reg Ex Query.yxmd

SylviaK

@Maskell_Rascal

Brilliant. It does work. Can you pls explain this expresison though? I get .*, but not the brackets and the bits in the bracket. many thanks

(?<=>).*

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703