Trying to Expand RegEx Knowledge for Data Parsing

Fellow Alteryx-ers,

I've been venturing out in the RegEx world more lately because I've run into some instances in my new role where it could be SUPER helpful with data cleanse/prep. I have a list of attributes (size and quantity) that I am trying to split up, but the values aren't always consistent...enter RegEx.

I've attached a little module with sample data I am working with. I will be the first to admit that the current expression is likely way more complicated than it needs to be, I was just using the "or" functions as I did some trial/error. My goal is to capture everything to the left of the 1st letter(s) in 1 new field and the everything else in a 2nd new field.

Here is an example of my current results:

Most of them are good to go...but I am not sure why I get some 2 decimal numbers and not others, and I can't seem to figure out how to handle for the hyphenated values.

Any help/guidance would be greatly appreciated!

RegExing.yxmd

Regex

Parse

Accepted answers

fmvizcaino

Hi @CTubbs ,

I'm attaching here an example showing how to get the values you need.

The only question is related to line 7, not sure if you want the 1 PK or 128 OZ

Best,

Fernando Vizcaino

RegExing.yxmd

All comments

fmvizcaino

Hi @CTubbs ,

I'm attaching here an example showing how to get the values you need.

The only question is related to line 7, not sure if you want the 1 PK or 128 OZ

Best,

Fernando Vizcaino

RegExing.yxmd

rkapoor

@CTubbs my go-to regex expert @rahmed may be able to help here 😉

DavidP

How about this?

([^[:alpha:]]+[[:alpha:]]+)(.*)

CTubbs

@fmvizcaino That works! Thanks for sharing that.

I see what you did with the "[...]" to capture the additional combinations. And as for that 1PK v 128 OZ piece, that is something I was going to error handle for prior to parsing so I will end up with the right data in the right fields. Thanks again.

CTubbs

@DavidP that also worked! I just tweaked it so the 2nd field didn't have spaces - ([^[:alpha:]]+[[:alpha:]]+)\s(.*)

Appreciate the feedback!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167