Deal with addresses

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 98
Accepted Solution

Deal with addresses

I am new here. My question might be a bit simple.

An address look like below in three different fields. To replace the spaces with other delimiter such as "+", what function can I use? Basically, I want to combine the three fields and have the format like"3430+East+Jefferson,+Detroit,+MI".

AddressCityState
3430 East JeffersonDetroitMI

Thanks a lot.


Accepted Solutions
Solution
‎07-12-2013 12:36 AM
Super User
Posts: 19,767

Re: Deal with addresses

Try the Translate() function to replaces spaces in address with +

and the catx function to concatenate the different variables with a ,+

View solution in original post


All Replies
Solution
‎07-12-2013 12:36 AM
Super User
Posts: 19,767

Re: Deal with addresses

Try the Translate() function to replaces spaces in address with +

and the catx function to concatenate the different variables with a ,+

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 146 views
  • 0 likes
  • 2 in conversation