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/120564.aspxMon, 11 Mar 2019 15:39:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120564Teddybeardog0https://www.infopathdev.com:443/forums/thread/120564.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120564You are awesome! Thanks so muchhttps://www.infopathdev.com:443/forums/thread/120563.aspxMon, 11 Mar 2019 15:07:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120563Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120563.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120563You could always use the translate function - translate(Field or Formula here, "|", "")https://www.infopathdev.com:443/forums/thread/120562.aspxMon, 11 Mar 2019 14:59:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120562Teddybeardog0https://www.infopathdev.com:443/forums/thread/120562.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120562I have a calculated value that uses substring-after and substring-before on the Accountid of my Approver Name field. I'm trying to get rid of the pipe character but can't figure how to do so. Minor but it's bugging me. TIA