Reformatting Mailing Address

[ProTuffProducts]

I am grabbing mailing address data from Hubspot and passing it along to another app. However, the mailing address is being provided as one complete address, as opposed to separated into fields such as street address, city, state, zip, country.

Is there a way to use one of the formatting features of Pabbly Connect to convert this address into multiple, separate pieces of data that can then be passed to another app (which needs them separated)?

 

[ArshilAhmad]

Hi @ProTuffProducts,

Could you please share the Workflow URL where you have this concern?

 

[ProTuffProducts]

Pabbly

connect.pabbly.com

I've actually gone to attempting to use a Python script written by ChatGPT in order to process this address information, but that is also not working. I keep getting the following error:

unknown extension ?P[ at position 2

 

[ArshilAhmad]

We have added two Text Formatter to your workflow. Please check if this gives you the desired result.