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

[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?

[SylviaK]

have tried this solution too. 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?

[vizAlter]

@SylviaK — Are you working on "Sheet1" or "Sheet2"? and on which column?

Please attached your workflow for sample.

And, did you notice that if you use "Text To Columns" tool then you are getting results in more than 2 columns? so do you want only two columns?

[ImadZidan]

Hello @SylviaK ,

See if this does the job.

Hope this helps.

[SylviaK]

Hi @ImadZidan 

Unfortunately it doesnt work. see attachment, for example I want cell A8 to be split into cell B8 and B9 as additional rows. The solution you provided is one additional column. 

Many thanks, 

Sylvia

[SylviaK]

@vizAlter Thanks vizAlter. 

I am reattaching the file. with just one sheet. many thanks for your help

[vizAlter]

@SylviaK — Is it what you are looking for?