I collect the City, State and Zip in 3 seperate PVs (pv!city, pv!state, pv!zip).

mikec over 10 years ago

I collect the City, State and Zip in 3 seperate PVs (pv!city, pv!state, pv!zip). I am using the append to show them in a single field in a record. append({rf!city,rf!state,rf!zip}). Here is what is displayed example: Knoxville; TN; 37922.

Is there a way to display these values as follows:

Knoxville, TN 37922

As you can see a comma and space seperate the city state and then 2 spaces seperate the state and zip.

Discussion posts and replies are publicly visible

0 Josh
Certified Lead Developer
over 10 years ago

try fn!concat(pv!city, ", ", pv!state, " ", pv!zip)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Owen Parrish
Appian Employee
over 10 years ago

The joinarray() function allows you to choose your separator.

forum.appian.com/.../Array_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 best
Certified Lead Developer
over 10 years ago

pv!city&", "&pv!state&" "&pv!zip
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 10 years ago

Mike, I agree with Josh's suggestion but remember that it will be worth putting this in a reusable rule as you may use it in many places.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikec over 10 years ago

thanks everyone, was a formatting issue on my side that you guys helped with.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel