⚙ Operations Hub

christine_Igles
Participant

Removing multiple types of punctuation from a field

Résolue

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!! 

0 Votes
1 Solution acceptée
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Removing multiple types of punctuation from a field

Résolue

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:

 

karstenkoehler_0-1672842470512.png

 

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
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Voir la solution dans l'envoi d'origine

3 Réponses
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Removing multiple types of punctuation from a field

Résolue

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:

 

karstenkoehler_0-1672842470512.png

 

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
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

AnaWilliam
Membre

Removing multiple types of punctuation from a field

Résolue

Thanks Karstenkoehler!

0 Votes
christine_Igles
Participant

Removing multiple types of punctuation from a field

Résolue

I will try this solution out. 

Thanks, Karsten.

 

PS: worked beautifully. Thanks again. 

0 Votes