Parse IF using an expression

[hellyars]

I have a Type ID stuck with the Title.  I know I can get to this by parsing, but it would require me to breakout all sorts of subsets.  I wish to avoid this.

Is there a way to write an expression that says. IF [GROUP]='01' THEN PARSE([TITLE], ([A-Z]{2}\d{3}).*$) ELSE [TITLE] ENDIF.  

START POINT.

Group	Type ID	Title
01		LH001 - Cervelo - Fast Bikes

DESIRED OUTPUT

Group	Type ID	Title
01	LH001	Cervelo - Fast Bikes

Again, I know I can use the Parse tool to do this....but I would prefer to use an Expression.

[afv2688 · Accepted solution]

Hello @hellyars,

Hope this helps

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[hellyars]

@afv2688  It works.  Sorry.  I went back and forth.  I actually had 90% of this formula, I forgot to add the '$1' to refer to the group.  THANKS.