removing a character :: from a string

shahm — Wed, 19 Jan 2022 23:14:55 GMT

Hello,

I have a column of data with english names and their french equivalent.

eg: type=Name::nom

I want to extract everything before the special characters of 2 colons i.e everything to the left of ::

how do I go about this.

Thanks,

Re: removing a character :: from a string

Reeza — Wed, 19 Jan 2022 23:16:48 GMT

SCAN function.

name_en = scan(type, 1, ":");
name_fr = scan(type, 2, ":");

@shahm wrote:

Hello,

I have a column of data with english names and their french equivalent.

eg: type=Name::nom

I want to extract everything before the special characters of 2 colons i.e everything to the left of ::

how do I go about this.

Thanks,

M

topic removing a character :: from a string in SAS Programming

removing a character :: from a string

Re: removing a character :: from a string