Trim muliple parts of a string

[Jmills040]

I have a field populated with strings with this name - file_hr_all_organization_units_f_20170505_020058203 - how do I remove the 'file_' portion and '_20170505' portion from the string, but keep the rest in one formula?

[NicoleJohnson · Accepted solution]

Try copying/using this expression with Replace output method in the RegEx tool (splits your string into 4 marked groups and then returns just the 2nd & 4th groups):

(.*)(hr_all_organization_units_f)(_\d{8})(.*)

Or... you can use the RegExReplace formula in the Formula tool (same result as above, just does it with a formula instead of the RegEx tool):

REGEX_Replace([Field1], "(.*)(hr_all_organization_units_f)(_\d{8})(.*)","$2$4")

Does that work? :)

NJ

[DanS]

Hey Jmills040, 

I attached a quick example of using Regex and Trim to do this that seems to get your desired result. 

Matching up to and including the first "_" from the beginning of the string and the end of the string.

I had some trouble with the regex expression for removing the last underscore. So I used the trim tool to take off the last one.

Thanks!

Dan