Keep the string after the _ (Trim / Regex)

[AJ-Fahmy]

I have a dataset that is like this:

Name

Instruments_Base__c

Cross_Selection_HR__c

CrossSelection_Base__c

VPN_Instruments_HR__c

T_and_S_Base__c

T_and_S_HR__c

VHS_3D_Recreation_Base__c

VHS_3D_Recreation_HR__c

Theoretical_Base__c

Theoretical_Products_HR__c

I only want to keep Base__c and HR__C ( that is Base Underscore Underscore C or HR Underscore Underscore C).

I'm not great when it comes to working with RegEx, so any help would be great.

Thanks

[MarqueeCrew]

@AJ-Fahmy ,

a pattern looking for it might be:

REGEX_Replace([field],".•_(\w+__\w)",'$1')

 cheers,

 mark

[Thableaus]

Hi @AJ-Fahmy 

If you use a filter tool you might use this regex:

Cheers,

[AbhilashR · Accepted solution]

Hi @AJ-Fahmy, assuming you are always only looking for Base__c or HR__c, you could use the following logic:

(Base__c|HR__c)

 

I have attached a sample workflow to help better understand my approach. Hope this helps!

[MarqueeCrew · Accepted solution]

Faster @AJ-Fahmy  would be:

IIF(Right([field],7)="Base__c","Base__c","HR__c")

 cheers,

 mark

[AJ-Fahmy · Accepted solution]

Awesome, yep, this is what I was looking for. Thank you @AbhilashR , for your help

[AJ-Fahmy]

Awesome, yep, this is what I was looking for. Thank you @MarqueeCrew for your help