Regex Error (but okay in Regex101)

[Bobbins]

Hello,

Text String;

"The very Blue Sea is always blue unless its orange when its not BLUE sea"

The idea is to split on every "blue" regardless of case to give:

The very

Blue Sea is always

blue unless its orange when its not

BLUE sea

This works in Reg101 but not in Regex as to parse it gives the error: "Error: Nothing to parse. Enter a complete expression."

Code is:
(?i)\s+(?=\bblue\b)

Thank you

[atcodedog05]

Hi @Bobbins 

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

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @Bobbins 

Here is how you can achieve the same

Hope this helps : )

[Bobbins]

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?

[atcodedog05]

Hi @Bobbins 

In your scenario you are breaking on n number of blues and also first column doesn't have blues hence its bit tricky.

@PhilipMannering do you have any suggestions on this.

Hope this helps : )

[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 · Accepted solution]

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.

[Bobbins]

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

[Bobbins]

@atcodedog05 Thank you also for your help :-)

[atcodedog05]

Just curious wouldnt my approach also work.

Happy to help : ) @Bobbins 

Cheers and have a nice day!