08-06-2014 11:07 AM
We are on the dfPowerStudio 8.2 version, but will soon be upgrading to Data Management Studio.
When we input a 2-line address into the Address Verification (US/Canada) node, the result from the address verification node is concatenating the input address line 2 to the first line of the address. We would like to be able to still have these lines separate after scrubbing. Is there a way to continue to keep these 2 lines separate after being scrubbed?
Ex: Input Address Line 1: 317 S Main St
Input Address Line 2: Apt 26
Input City - State: Milbank, SD
Input Zip: 57252
Result from Address Verification Node:
Address Line 1: 317 S Main St Apt 26
Address Line 2:
08-06-2014 12:44 PM
Try using the Parsing node using the Address Definition for the Address Line 1 field. Output all available tokens then use an expression to concatenate the parsed tokens into Address Line 1 or Address Line 2:
/* Pre Expression */
addr_1_update = ''
addr_2_update = ''
/* Expression */
addr_1_update = `Street Number` & ' ' & `Pre-direction` & ' ' & `Street Name` & ' ' & `Street Type` & ' ' & `Post-direction`
addr_2_update = `Address Extension` & ' ' & `Address Extension Number`