RegEx - Tokenize

[SylviaK]

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

[SylviaK]

@vizAlter No - not really. Have made it more clearer in the attachment. many thanks

[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

[SylviaK · Accepted solution]

@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

(?<=>).*

[Maskell_Rascal]

 Hey @SylviaK 

Glad it worked for you! It breaks down as follows:

?= Positive Look Ahead

.* Matches any character (except newline)

() Groups

So ?= is used to identify ">", but we don't want to select ">". So I'm using a ?<= to find ">", but not select it while still looking forward. 

I hope that makes sense. 

Thanks!

Phil