My CRM has me input all the address fields separately but sends it to Zapier in an odd format. I need to pull only the street address portion. Here is an example of what is pulled over to Zapier.
123 N Zapier St Lutz, FL 33549 US
I can’t use the comma separator because there’s no comma in from of the city name and if I use a space separator then it’ll be different each time depending on if there a street direct or multi word street name. Any suggestions on how I could get this to work?