Replace single quote with double quotes

[#1]

Hi Guys

could you please help me how to replace single quote with double quotes in data services

I have tried with replace_substr(column_nm, '''','"')

but it is giving an error on parsing:-

<Syntax error at line <1>: <>: near <'> found <;> expecting <')', ','>

Regards

[vnovozhilov]

Screen the single tick: replace_substr(column_nm, '\'','"')

Thank you,

Viacheslav.

[Former Member]

Hi Viacheslav,

If this is working , please mark this answer as correct answer.

Regards

Annesha

[vnovozhilov]

It wasn't me who raised the question. I used to be SCN Moderator for Data Services in the past but I am not anymore.

Thank you,

Viacheslav.

[former_member208363]

Hi,

Please try as shown below:

replace_substr(DATE_Table.Remarks,'\'','"')

[Former Member]

Hi,

The solution is you need to override the single quote with \'

so put '\''

The solution is

replace_substr(column_nm,, '\'','"');

I checked this is working

Thanks

Annesha