That works in rewriting the database file name from johndoe's.pdf to johndoes.pdf but the actual filename is changed to johndoe\s.pdf and stored in the folder as that.
Should I change the bindings in the file manipulation upload wizard File upload from [FileName] to [Server File Name] ?
Yes, you should bind to the Server File Name value for your Data Assist insert.
Cheers
Ian