Page 1 of 1
how to pass quotes single& double as argument to conver
Posted: Mon Oct 25, 2010 1:56 am
by 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?
Posted: Mon Oct 25, 2010 2:33 am
by 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:
hope this will help.
Regards,
Raja R P
Posted: Mon Oct 25, 2010 2:44 am
by 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.
Posted: Mon Oct 25, 2010 5:09 am
by HariK
Convert('"','',Convert("'","",(yourstring)))
unless you want to accomplish the whole thing using only one instance of convert function.
Posted: Tue Nov 02, 2010 12:24 pm
by anbu
Code: Select all
Convert( "'" : '"',"",Input)
Convert( Char(047) : Char(042),"",Input)