https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122305.aspxMon, 27 Jan 2020 19:44:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122305srudenko0https://www.infopathdev.com:443/forums/thread/122305.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122305I think I found an answer from another post on this form. Translate doesn't seem to work to change ;; to ; but this does: concat(substring-before(Emails, ";;"), ";", substring-after(Emails, ";;"))https://www.infopathdev.com:443/forums/thread/122304.aspxMon, 27 Jan 2020 19:29:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122304srudenko0https://www.infopathdev.com:443/forums/thread/122304.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122304Thank you. That worked but now I have a follow up question. Since I have 5 check boxes to create the email string there are many combinations and when adding / removing checks randomly I am running into output where the email address goes away once checkbox is unchecked but extra semicolons remain. EX: aaa@invesco.com;;ccc@invesco.com;ddd@invesco.com; So I tried adding a rule on that email string field Condition - When field contains ";;" Action - translate(., ";;",";") That doesn't seem to do anything however. I am sure I am missing something or doing it incorrectly.https://www.infopathdev.com:443/forums/thread/122297.aspxFri, 24 Jan 2020 17:33:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122297Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122297.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122297On the field that is being set (target field) add a rule. The condition on the rule be if the target field begins with ; and the rule will use a substring formula to reset. See attached sample - save the linked file locally. Right click and select design. Preview and enter text that starts with ;https://www.infopathdev.com:443/forums/thread/122296.aspxFri, 24 Jan 2020 16:43:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122296srudenko0https://www.infopathdev.com:443/forums/thread/122296.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122296Hello Lets say I have a text field that gets populated with values based on other controls in the form and the value is something like this: ;aaa@email.com;bbb@email.com;ccc@email.com How do I remove the first character in a string ONLY if it starts with ; If its anything else then leave it as-is? Thanks