Tips, Tricks & Best Practices

JRobertshaw
Participant

Cleaning a Data String

SOLVE

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 

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Cleaning a Data String

SOLVE

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!

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.

View solution in original post

1 Reply 1
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Cleaning a Data String

SOLVE

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!

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.