Removing Punctuation from a string

[maynard444]

Hi all,
I need some help in removing the punctuation from a string. For example:
I want O'KEEFE to look like OKEEFE
Any info would be helpful.
Thanks,
Heath

 

[lbass]

You can use the replace function:

replace({table.string},"'","&quot

You can also nest "replaces" to remove several kinds of punctuation as in:

replace(replace({table.string},"'","&quot,":","&quot

-LB

 

[maynard444]

Thanks, that does exactly what I need.
Heath