Regex Error (but okay in Regex101)

Hi @Bobbins

Here is how you can achieve the same

Hope this helps : )

blue.yxmd

apathetichell

I've attached the way to split with case...

The key is tokenize the words, use a multi-row formula to index them by Blue (with a normalized case) and then concatenate in crosstab.

split blue with case.yxmd

So it does..

This looks about right,

Blue.yxmd

The pipe | means "or". And $ means end of line.

So in this case we're saying that we want to capture text up until a "blue" or "end of the line".

Thinking about it, you'll want to use (?=\bblue\b|$) to split on blue as a word...if you didn't want to split on, say, "bluetooth".

All comments

Hi @Bobbins

Reg101 doesn't handle parse hence you are getting this issue in Alteryx.

Hope this helps : )

Hi @Bobbins

Here is how you can achieve the same

Hope this helps : )

blue.yxmd

Thanks thats one way to solve it, can you use Regex to do the same so i can keep the case of what i am breaking up?

apathetichell

What you are doing is tokenizing since you are taking one column and splitting it into multiple components. Alteryx tokenizing supports exactly 1 marked group. You have two marked groups - hence this is not doable in Alteryx.

On a purely matched group process - you can see that you have 3 matched groups if you use:

REGEX_CountMatches([Field1],"(?i)\s+(?=\bblue\b)")

I would also note - that regex 101 gives you match information (ie the number of matches) but it does not show you the values of those matches (like you would expect to see from a succesful Regex tokenizing) see the difference between your expression and say:

(\s\w+\s)

where every match in Regex 101 also returns a group.

apathetichell

I've attached the way to split with case...

The key is tokenize the words, use a multi-row formula to index them by Blue (with a normalized case) and then concatenate in crosstab.

split blue with case.yxmd

Thank you kindly, thats a different way to how i was thinking it could be done!

@atcodedog05 Thank you also for your help :-)

Just curious wouldnt my approach also work.

Happy to help : ) @Bobbins

Cheers and have a nice day!

You can also tokenize on this,

(.+?)\s+(?=blue|$)

No need to worry about the (?i) - you can just have the case insensitive box ticked.

Interesting @PhilipMannering

Running this it picks up the first two blues but the all in caps BLUE it fails

So it does..

This looks about right,

Blue.yxmd

Wow, thanks for that. Question over the regex part, whats the pipe for in "(?=blue|$)"

The pipe | means "or". And $ means end of line.

So in this case we're saying that we want to capture text up until a "blue" or "end of the line".

Thinking about it, you'll want to use (?=\bblue\b|$) to split on blue as a word...if you didn't want to split on, say, "bluetooth".