https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/79662.aspxTue, 19 Jun 2012 20:04:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79662kasobus0https://www.infopathdev.com:443/forums/thread/79662.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=79662SOLUTION: In case anyone else has this question I figured it out! translate(normalize-space(Groups-Users), " ", ";") Remove the spaces which for some reason does not remove all spaces then translate that one space in a semicolon! :)https://www.infopathdev.com:443/forums/thread/79661.aspxTue, 19 Jun 2012 19:33:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79661kasobus0https://www.infopathdev.com:443/forums/thread/79661.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=79661I tried that and it adds like 5 semicolons. :( If there is a way to add then and then remove all but 1, I would be fine with that too.https://www.infopathdev.com:443/forums/thread/79657.aspxTue, 19 Jun 2012 18:16:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79657Anson Hidajat0https://www.infopathdev.com:443/forums/thread/79657.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=79657Perhaps the replace() function will work in your case?  Just replace all instances of spaces (" ") with semicolons (";").  Hopefully that will work for you.https://www.infopathdev.com:443/forums/thread/79653.aspxTue, 19 Jun 2012 16:10:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79653kasobus0https://www.infopathdev.com:443/forums/thread/79653.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=79653The data below is being pasted into a text box. Then when the user switches to the next view (via button) a text box will be in it's place but will reformat the data...   INPUT FIELD NAME: Groups-Users    NAMG_DEDocs_Authors     NAMG_DEDocs_Invoice_Authors     NAMG_DEDocs_Invoice_UserAdmin     **DESIRED OUTPUT** FIELD NAME: Formatted-Groups-Users NAMG_DEDocs_Authors;     NAMG_DEDocs_Invoice_Authors;     NAMG_DEDocs_Invoice_UserAdmin;    If someone can help me do this that would be great! Thanks! -Kyle