07-12-2013 12:28 AM
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".
|3430 East Jefferson||Detroit||MI|
Thanks a lot.
Need further help from the community? Please ask a new question.