Need help parsing address field

[MrAutomate]

HI,

I have a web form a client can fill out that comes to email.  I do not control this form, it is by a 3rd party vendor.  They do not enforce State formats, ie, VA,va,Virginia, etc.

I have a flow that I had working until the word Virginia changes to VA or is missing totally.

Example:  5600 powell grove dr midlothian va 23112

I had it working if it were formatted like this:

5600 powell grove dr midlothian Virginia 23112 with these splits:
trim(split(split(body('Filter_array')[12],' Virginia')?[0],' ')?[sub(length(split(split(body('Filter_array')[12],' Virginia')?[0],' ')),4)])
trim(split(split(body('Filter_array')[12],' Virginia')?[0],' ')?[sub(length(split(split(body('Filter_array')[12],' Virginia')?[0],' ')),3)])
trim(split(split(body('Filter_array')[12],' Virginia')?[0],' ')?[sub(length(split(split(body('Filter_array')[12],' Virginia')?[0],' ')),2)])

Now I see that will not work.

I can get the Zip code.  Last(split(outputs('Full_Address'),' '))

  (Full Address is a compose : trim(split(body('Filter_array')[12], ':')[1])    )

What code will help me go:
1 word left of the Zip for the State

2 word left of the Zip for the City

Then, throw way those 3 values , leaving the street address?

Appreciate suggestions.

Thanks!

[VictorIvanidze]

Try an alternative: retrieve the state and the city based on zip.

Here is an example: https://ivasoft.com/gettimezonebycountrycodeandzip.shtml 

[MrAutomate]

Victor, thanks for the response.  In general, I prefer to avoid additional platform dependencies wherever possible.  I am sure someone in the community has ran across this and will have suggestions to solve this..

[BhargavPatel]

Parsing Street number, State, and Zip is feasible. However, the difficult part will be parsing out the Street Name and City because both of them can be more than one word. You need a comma (,)  at the end of the street name. 

[VictorIvanidze]

Could you share what exactly returns the web form?

[AlexEncodian]

@MrAutomate 

You could use a Regex query. You can easily write regex queries using ChatGPT but make sure to test them properly. The regex query I used in my test:

\b([a-zA-Z]+)\s+(?=\d{5}(?:-\d{4})?$)

• \b([a-zA-Z]+): Matches any word consisting of alphabetical characters (both lowercase and uppercase) that is preceded by a word boundary.
• \s+: Matches one or more whitespace characters.
• (?=\d{5}(?:-\d{4})?$): This is a positive lookahead assertion that checks for the presence of either a five-digit ZIP code or a ZIP+4 code at the end of the string. It ensures that the word before these digits is captured.

I set up a quick test flow:

The result was correct:

You could do something similar for 2 words left of the zip code and then use Utility - Extract Text between Values to extract between start of string (leave start value blank) and the result of the 2 words left of the zip code.

Will you still get full state names? What if the state name is a two letter word? You could also use a AI text prompt to extract the part of the address you want in the correct format.

Note the action returns 1 or more matches therefore the result is in an array format. If you know there is only a single match, simply compose a first() expression inserting the dynamic output from the Encodian action. This will return the first (and only in your case) match and will avoid for each loops being inserted while you build your flow.

FYI - Encodian "utiltiy" actions, those actions prefixed with utility in their name, consume only 0.05 credits per operation. Meaning you can run 10,000 regex queries in the Standard plan that comes with 500 credits. You can also run 50 queries free per month.

[MrAutomate · Accepted solution]

Sure- This is the output of the Filter array that removes any blank row:

The underlined lines are the relevant lines I need

[

  "Congrats! Sammy Jones just filled out your ZenMaid booking form [Form#946GP]!",

  "[https://i.imgur.com/jp92UDX.png] [https://app.zenmaid.com]",

  "HEY SUZIE SMITH!",

  "Congrats! Sammy Jones just filled out your ZenMaid booking form [Form#946GP]!",

  "CUSTOMER INFO",

  " * Name: Sammy Jones",

  " * Email: lhjunk@me.com",

  " * Phone: 8045551212 [tel:8045551212]",

  "BOOKING DETAILS",

  "Name: Sammy Jones",

  "Phone Number: 8045551212",

  "Email: lhjunk@me.com",

  "Address: 5600 powell grove dr midlothian va 23112",

  "Service Time: Unknown Date - ?",

  "Service Details: 1200 sqft, 1 bedrooms, 1 bathrooms",

  "Estimated at: $0.00",

  "Credit Card saved on file: No",

  "Click here to view this lead in ZenMaid [https://app.zenmaid.com/bookings]",

  "PS: Did you know the faster you contact the person above the more likely you are",

  "to guarantee their business? Click the phone number above and get 'em on the",

  "line! ?",

  "© 2023 ZenMaid. All rights reserved.",

  "[https://ea.pst