ParseMultilineAddress

Splits the value of the current field at each comma and saves the substrings to the specified fields. Typically used for address fields.

Syntax

bool ParseMultilineAddress (strParam)

Parameters

Smart parameters are supported. Comma-separated Smart Parameter String values of the names of fields that hold the parsed data, in the following order:

Name, AddressLine1, AddressLine2, City, State, Zip code or postal code, Phone

Returns

False, if the parameters are invalid or parsing cannot take place. Otherwise, True.

Level

Field level.

Details

Parses a multiline US address Field object's captured value.

Comma-separated String values of the names of fields that hold the parsed data, in the following order: Name, AddressLine1, AddressLine2, City, State, Zip code or postal code, and Phone. The example assumes that fields are sibling fields of the calling object. For other relationships, review smart parameter syntax.

Expected Pattern:
  • Phone Number (optional)
  • Name
  • Address Line One
  • Address Line Two (optional)
  • City, State, Zip code or postal code
  • Phone Number (optional)
Note: Parsing logic assumes that State and Zip or postal code are on the same address line. Only one Phone number per address field is supported. The expected pattern shows the two optional positions for this value.
Example
ParseMultilineAddress("VendorName,VenAddress1,VenAddress2,VenCity,VenState,VenZip,VenPhone")