I'm trying to bring address data from one DB field into another DB field. Sounds too easy, right, there's a but: I need to reformat the data from this:
City, St Zip
First Last, 1234 Address, City, St Zip
I basically need to drop the returns and insert commas...
Any help would be appreciated.