how to pass quotes single& double as argument to conver

[sk39758]

Hi ,


I want to pass " (double quote) and ' (single quote) as first argument to convert function.
Could some one tell me how to do that?

[RAJARP]

Hi,
For single quotes

convert( '<from character>',"<single quote within pair of double quotes>",link.field)

example :

i/p data==>raja*s
o/p required==>raja's

code:

Code: Select all

convert('*',"'",raja*s)

hope this will help.

Regards,
Raja R P

[sk39758]

Hi ,

My input string contains double quote and single quote both and i want both to be removed.

input string -"india's"
output shud be indias
i wanna do this using convert function so my question is how to mention single and double quote in first agrument of convert function.

[HariK]

Convert('"','',Convert("'","",(yourstring)))
unless you want to accomplish the whole thing using only one instance of convert function.

[anbu]

Code: Select all

Convert( "'" : '"',"",Input)
Convert( Char(047) : Char(042),"",Input)