Hello all, I am new to RegEx and Alteryx as a whole and could really use some assistance.
I have the following rows:
ROCK:NO, BAT_APP:LEVEL STATUS One, TEST:Y, MONTH:AUG
BAT_APP:LEVEL STATUS Two, TEST:Y, MONTH:SEP
ROCK:NO, BAT_APP:LEVEL STATUS Three, TEST:Y, MONTH:OCT
I am just trying to parse the colored text, which is everything that begins with the word BAT_APP to the text before the first comma.
I have tried using lookaheads but can't seem to get the function to work, or include the text BAT_APP.
Any help would be greatly appreciated.
Thanks!
You can make this simpler, but I've done this :
Substring([field],FindString([field], "BAT_APP"))
and then this:
left([new], FindString([new], ","))
@Hoss2434
I gave a try with RegEx.