Replace letter in string

Sean_OConnor — Thu, 13 Jul 2023 15:52:00 GMT

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

Re: Replace letter in string

Reeza — Thu, 13 Jul 2023 15:56:23 GMT

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

topic Re: Replace letter in string in SAS Enterprise Guide

Replace letter in string

Re: Replace letter in string