Apostrophe in names - Is there a way to remove?

[c9ola]

When InfoPath connects to our HR database and brings back a person's name . .
.. some have apostrophes . . . O'Riley, O'Brien, etc... Then it passes that
name value to an Access database. When I write SQL to do a search in Access,
it can't handle the apostrophe. I was hoping I could find a way to deal with
it in InfoPath before it ever gets to the Access db. Does anyone know how I
can remove the apostrophe as it is pulled in from the HR db, or as the data
is being sent to the Access db? Thank you.

 

[Clay Fox]

You can use the functions for string-before and string-after to remove the '

name = concat(string-before(name, "'"), string-after(name, "'"))

You may also find the Database Accelerator helpful if you are using backend
data in your form. I have done several HR related solutions and the web
services make it much easier to work with the data.
http://www.qdabra.com

Let me know if you have any questions.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com