InfoPath Dev

Awesome! I use the first solution and it completely works. I spent about couple days on this issue actually. Thank you very much. By the way, please allow me to ask some stupid questions. Although the formula works, I quite confuse about its function, so would you please explain some more detail about this formula? Thanks, One.

I try using formula to replace special characters to underscore: translate(field1, ",, :, ;, ', "", "_") However, the formula contains error because of the double quotes. Would anyone please tell how to escape the double quotes for InfoPath 2010? I also try adding anoher field containing the double quotes as ...