InfoPath Dev

I'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?

As 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?

think 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 away

while i'm at it... how do you replace " and ' ? how do you escape them in the replacement pattern? Thanks in advance :)

never 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.