https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/103727.aspxWed, 26 Aug 2015 18:20:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103727Carphunter0https://www.infopathdev.com:443/forums/thread/103727.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=103727never mind. figured it out. made a field that i populated with all the charactes to replace, and then added that to the translate formula in stead of the quoted characters.https://www.infopathdev.com:443/forums/thread/103726.aspxWed, 26 Aug 2015 18:04:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103726Carphunter0https://www.infopathdev.com:443/forums/thread/103726.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=103726while i'm at it... how do you replace " and ' ? how do you escape them in the replacement pattern? Thanks in advance :)https://www.infopathdev.com:443/forums/thread/103725.aspxWed, 26 Aug 2015 18:00:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103725Carphunter0https://www.infopathdev.com:443/forums/thread/103725.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=103725think i found the glitch. in my formula i have the quoted field name section separated from the quoted character section with ,[space]. When i remove the space, my problem goes awayhttps://www.infopathdev.com:443/forums/thread/103724.aspxWed, 26 Aug 2015 17:44:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103724Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/103724.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=103724As long as there isn't a space between the last set of quotes, you shouldn't be getting spaces - you should be getting nothing. I just tested your formula, and it worked for me as anticipated. Want to attach a form or some screenshots under the Options tab in a reply to show me the issue?https://www.infopathdev.com:443/forums/thread/103723.aspxWed, 26 Aug 2015 17:37:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103723Carphunter0https://www.infopathdev.com:443/forums/thread/103723.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=103723I've got a field i'm running the formula translate(fieldname, "!@#$%%", "") trying to replace those characters with nothing...no space, no dash, etc. The way i've written it here...i get spaces as replacements. How do i get the characters deleted?