Cleaning a Data String

[JRobertshaw]

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 

[karstenkoehler · Accepted solution]

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!