RegEx - Tokenize
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.*)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@vizAlter Thanks vizAlter.
I am reattaching the file. with just one sheet. many thanks for your help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
