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

**URL:** <https://community.hubspot.com/t/how-can-i-use-custom-format-data-to-remove-non-consistent-text/87574>\
**Category:** Data Hub\
**Tags:** format-data-actions\
**Created:** [August 16, 2023, 12:13am UTC](https://community.hubspot.com/t/how-can-i-use-custom-format-data-to-remove-non-consistent-text/87574 "2023-08-16T00:13:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KimRogers](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kimrogers/32/57930_2.png) [@KimRogers](https://community.hubspot.com/u/KimRogers)\
**Post date:** [August 16, 2023, 12:13am UTC](https://community.hubspot.com/t/how-can-i-use-custom-format-data-to-remove-non-consistent-text/87574/1 "2023-08-16T00:13:29Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [August 16, 2023, 4:16am UTC](https://community.hubspot.com/t/how-can-i-use-custom-format-data-to-remove-non-consistent-text/87574/2 "2023-08-16T04:16:44Z")

</div>

Hi @KimRogers,

You can cut the section using the custom mode in the format data action and the regex\_replace fomula:

 ![karstenkoehler_0-1692159389767.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/1/51bb2ee996eb6cff82efe1ef1826cff8f87577f7.png)

Best regards!

---

<div class="post-metadata">

**Author:** ![KimRogers](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kimrogers/32/57930_2.png) [@KimRogers](https://community.hubspot.com/u/KimRogers)\
**Post date:** [August 17, 2023, 7:14am UTC](https://community.hubspot.com/t/how-can-i-use-custom-format-data-to-remove-non-consistent-text/87574/3 "2023-08-17T07:14:28Z")

</div>

Thanks so much @karstenkoehler !