topic Cleaning a Data String in Tips, Tricks & Best Practices

Cleaning a Data String

JRobertshaw — Wed, 21 Dec 2022 02:31:08 GMT

Hi All,

We have an address field that is populated by a third party extension, as the value used in the extension comes from html it is populated with all the line breaks <br> in the text field.

We use this property to populate emails that go out, so would like to remove the <br> from the text.

Is there a way that we can clean this data automatically?

Thank you

Re: Cleaning a Data String

karstenkoehler — Wed, 21 Dec 2022 05:09:49 GMT

Hi @JRobertshaw,

Yes, this is possible in workflows with the Format data action, does however require an Operations Hub Professional subscription.

Without Operations Hub Professional, you'd have to look into third-party custom automation like Zapier.

Best regards!