topic Re: How can I use Custom Format Data to remove non consistent text in Data Hub

How can I use Custom Format Data to remove non consistent text

KimRogers — Wed, 16 Aug 2023 00:13:29 GMT

Not sure if this is even possible, but I'm trying to use Format Data in workflows to remove text from a Deal property

The problem I have is that the text I am trying to remove differs on each deal.

For example the deal name is "Joe Bloggs (TL) 01/01/23".

The name convention is the contacts name followed by the initials of the Sales Representative, followed by the date the deal was closed.

I want to cut the section "(TL) 01/01/23" from the deal name, so keep the name of the contact but remove the initials and date.

Is there a way to do this with Format Data in workflows?

karstenkoehler — Wed, 16 Aug 2023 04:16:44 GMT

You can cut the section using the custom mode in the format data action and the regex_replace fomula:

Best regards!

KimRogers — Thu, 17 Aug 2023 07:14:28 GMT

Thanks so much @karstenkoehler !