Conditional Regex

mweiser_dup_512

Hi Alteryx Community,

I am trying to tokenize a series of strings with letters, numbers, and special characters by every instance of a capital letter of a word, but I only want to tokenize if there is no "/" in between two words. How would I go about that? The data is very random and inconsistent. Ideally I would like to tokenize by the "/" but every now and then there is a date using "/" so I am attempting to go with each capital letter.

For example:

Polar Bear / Train (CAR) 18-19 / Nickel/Vacation 1/2 - 1/6/ CAT 1/3 Alligator X&Y / FLOMINGO / Vulture/GORILLA / HOMECARE2 Provide

To turn into:

Polar Bear

Train (CAR)

Nickel

Vacation

CAT

Alligator X&Y

FLOMINGO

Vulture

GORILLA

HOMECARE2 Provide

Bob_Blackey

Hi Matt,

Regex is fun because how you build it really depends on your data and your knowledge of how quirky it can be. 

Based on your original post it look like you want to keep "HOMECARE2 Provide" and the numbers you want to get rid of are the dates.

so what I did is first replace the possible dates with nothing.

The first replace gets rid of dates with either 2/17 or 12/15 format, the second with either 2-17 or 2-15.

As I said regex is a great tool, but how complex your expressions are depends on how extreme your data is.

Cheers,

Bob

regex.yxmd