We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).
a month ago
What is the best way to remove unnecessary punctuation from a field? For example, a job title might include the following characters; a comma, fwd slash, and an ampersand.
We want to remove all 3 characters from the title to keep the data clean and syncing.
Should I create a WF for each of the characters that I want to cut or is there a way to build one workflow to cut them all at once?
Thanks!!
Solved! Go to Solution.
a month ago
Hi @christine_Igles,
It sounds like you're using the Format data action in workflows for this, correct? (Operations Hub Professional is great.)
If you always want to check for and replace the same characters, I would simply chain Format data actions, using the Replace characters option:
By chaining I mean that you have a first action that replaces commas, followed by another action that replaces forward slashes, followed by another action...
Let me know if you have any follow-up questions!
Karsten Köhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
a month ago
Hi @christine_Igles,
It sounds like you're using the Format data action in workflows for this, correct? (Operations Hub Professional is great.)
If you always want to check for and replace the same characters, I would simply chain Format data actions, using the Replace characters option:
By chaining I mean that you have a first action that replaces commas, followed by another action that replaces forward slashes, followed by another action...
Let me know if you have any follow-up questions!
Karsten Köhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
4 weeks ago
Thanks Karstenkoehler!
a month ago - last edited a month ago
I will try this solution out.
Thanks, Karsten.
PS: worked beautifully. Thanks again.