Changing format of text field
I have a datafield that is currently used as the name and mailing address of Customer, call it data1. Each line is seperated with a carriage return.
I'd like to be able to create another datafield, call it data2, that would take the contents of data1 and give it to me in a comma seperated format.
So, basically, I'd like to Data1:
And copy it to Data2 as:
Name, Address, City, State Zip
Is this possible?