Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
2413 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
I collect the City, State and Zip in 3 seperate PVs (pv!city, pv!state, pv!zip).
mikec
over 9 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.
OriginalPostID-137881
OriginalPostID-137881
Discussion posts and replies are publicly visible
0
Josh
Certified Lead Developer
over 9 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 9 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 Senior Developer
over 9 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 9 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 9 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