regex help parsing

I use the following to parse name space name and it works great with the following exception:
(^.*?\s.*?[+]|^.*?\s.*?\s)

This regex works for me on literally everything, except this one instance of Otterbox. Does anyone have any idea why it works on the one, but not the others? To be clear, the goal is the first one. I have also tried renaming the description in various ways to no avail (and would rather rename the description than change the regex probably). Thanks

Book1.xlsx

Regex

Accepted answers

atcodedog05

Hi @hudg16

You can regex like below.

Workflow:

Hope this helps : )

Iphone.yxmd

mst3k

your formula

^.*?\s.*?[+]

i believe this says start with anything until a space, then anything up until a +, which grabs that "OTTERBOX" word in between.

the first row is working correctly only because it's using the 2nd half of your regex after the OR | since there is not a + in the first value. it satisfies the rule

^.*?\s.*?\s

start with anything up until a space, then anything up until a space again

if the goal is just the value from the first line, what's wrong with what you've already got in the 2nd part of your formula, just using that? i would move the last \s out of your marked group though, or else you'll have to strip the trailing whitespace later

in parse mode: (^.*?\s.*?)\s

All comments

atcodedog05

Hi @hudg16

Can you provide some expected output it will help us get a better understanding of the usecase.

hudg16

The expected output is the first row of that table, and Alteryx does that "iPhone 13PRMX", but also proceeds to add Otterbox into some of them for some unknown reason.

mst3k

your formula

^.*?\s.*?[+]

i believe this says start with anything until a space, then anything up until a +, which grabs that "OTTERBOX" word in between.

the first row is working correctly only because it's using the 2nd half of your regex after the OR | since there is not a + in the first value. it satisfies the rule

^.*?\s.*?\s

start with anything up until a space, then anything up until a space again

in parse mode: (^.*?\s.*?)\s

hudg16

The weird thing is that it works for items like
IPHONE 11 CASECO FREMONT GLITTER BLACK >>>>> IPHONE 11

But on my first run here, this new expression works good. Thanks.

mst3k

that's because your original formula

(^.*?\s.*?[+]|^.*?\s.*?\s)

is basically 2 formulas in 1,

^.*?\s.*?[+] OR ^.*?\s.*?\s

There's no "+" in the value "IPHONE 11 CASECO FREMONT GLITTER BLACK >>>>> IPHONE 11" so it doesn't use this formula, and uses the second one instead, which works on its own for all your values

I'm not 100% sure it's actually looking for the value "+" either, since + is one of the codes for regex, it may be interpreting it slightly differently (a strict + would have needed an escape like \+ I think? but I'm not totally sure), but for all intents and purposes it's that first formula that's triggering the rows you don't want as far as I can tell. So it only messes up for your values that have that + in it

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703