Jan 4, 2023 9:24 AM
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.
Jan 4, 2023 9:28 AM
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. |
Jan 4, 2023 9:28 AM
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. |
Jan 7, 2023 3:54 PM
Thanks Karstenkoehler!
Jan 4, 2023 1:21 PM - edited Jan 4, 2023 1:36 PM
I will try this solution out.
Thanks, Karsten.
PS: worked beautifully. Thanks again.