Need help parsing string using RegEx

[Hoss2434]

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!

[cmcclellan]

You can make this simpler, but I've done this :

Substring([field],FindString([field], "BAT_APP"))

and then this:

left([new], FindString([new], ","))

[Qiu]

@Hoss2434 
I gave a try with RegEx.

[atcodedog05]

Hi @Hoss2434 

My take on this. Using regex tool parse mode.

Workflow:

Hope this helps : )