2 Replies Latest reply on Sep 1, 2009 2:33 PM by PBratton

    Changing format of text field



      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:




      City,State  Zip


      And copy it to Data2 as:


      Name, Address, City, State  Zip


      Is this possible?