Copy only numeric characters from one property to another via Workflow

[MRodrigues8]

I have a property "A" of type Text Field that can receive text in two formats: either 14-digit numbers or 18-digit strings containing numbers, dots, dashes, and slashes.

perationally, I cannot change how this property is populated.

I need to create a new property "B" to copy the original value from property "A"if it consists only of numbers. However, if "A" contains additional characters like . - /, I need to extract and copy only the numeric characters to "B"

Can I achieve this through a Workflow, even if it requires some code? Any help would be greatly appreciated.

Thank you!

[karstenkoehler · Accepted solution]

Hi @MRodrigues8,

This can be achieved via two means, custom coded workflow actions and the format data action workflows. Both require Operations Hub Professional or Enterprise and the latter (format data) is easier to use, so that's the one I'd recommend.

https://knowledge.hubspot.com/workflows/format-your-data-with-workflows

Within format data, you can select Custom mode and either type a replace formula or use regex to do so:

Sample input

Formula and output

Let me know if you have any follow-up questions!