Need to remove one character from name field

[macmikey]

I have my last name field and use it to calculate the email addresses we use in our office. I need to have a calc that will remove the ' (apostrophe) for a name like O'Neill or O'Shea.

Can anyone help? The calcs I have tried either do nothing or completely wrong output I simply want the name to go from O'Neill to oneill, case does not matter.

Thanks,

Mike

Version: v6.x

Platform: Mac OS X Panther

[MoonShadow]

Set Field [ Lower(Substitute( NameField, "'", "")) ]

[macmikey]

Isn't this a Script calc? I just need a field calc. Not running a script to change these. Want to do it on entry of text to lastname field.

Version: v6.x

Platform: Mac OS X Panther

[macmikey]

sorry, my bad. i saw 'set field' and assumed it was the calc set field.

I got it now.

Mike

Version: v6.x

Platform: Mac OS X Panther

[MoonShadow]

Sorry about that. Went immediately back to edit to say you could use script or calc with same calculation but my system froze on me.