Replace letter in string

[Sean_OConnor]

Hi Folks,

I have a list of surnames in a string and I need to replace say O'Con or O'S with O Con or O S.

I've tried to this and I'm struggling so any help welcome.

All the best,

Sean 

[Reeza · Accepted solution]

Have you tried TRANSLATE function?

surname_no_apostrophe = translate(surname, " ", "'");

Last parameter is single quote/apostrophe, wrapped in double quotes. 

---

@Sean_OConnor wrote:

Hi Folks,

I have a list of surnames in a string and I need to replace say O'Con or O'S with O Con or O S.

I've tried to this and I'm struggling so any help welcome.

All the best,

Sean 

---