how to remove starting and ending duoble quotes

parvathi · Post by **parvathi** » Fri Feb 16, 2007 5:02 am

Hi
I have varibale with in duoble quotes

ex var="hello"

I want the variable without duoble quotes

just var = hello

how can i do this?

ArndW · Post by **ArndW** » Fri Feb 16, 2007 5:19 am

Use TRIM(Your.ColumnName,'"','B')

ray.wurlod · Post by **ray.wurlod** » Fri Feb 16, 2007 5:36 am

Or InLink.ColName[2,Len(InLink.ColName)-2]

Or Field(InLink.ColName, '"', 2, 1)

Question: which of the three methods is the most efficient?

parvathi · Post by **parvathi** » Fri Feb 16, 2007 6:06 am

Thanks a lot
Trimming with field function i find it as the most efficient

But Even trim functions is also easier to me

kumar_s · Post by **kumar_s** » Fri Feb 16, 2007 6:15 am

Thanks for mentioning the option that you going to use. So its time for you to mark the topic as resolved.

kejuste · Post by **kejuste** » Thu Jan 28, 2010 1:58 am

I tried using all the there options.

I found function InLink.ColName[2,Len(InLink.ColName)-2] is more useful than other.

thanks Ray

chulett · Post by **chulett** » Thu Jan 28, 2010 6:19 am

Hmmm... I would use Convert() for that.

Convert('"','',InLink.ColName)

ray.wurlod · Post by **ray.wurlod** » Thu Jan 28, 2010 3:24 pm

I'd be more cautious and check first that the characters occur only on the ends.

If InLink.TheString Matches \'"'0X'"'\ Then InLink.TheString[2,Len(TheString)-2] Else InLink.TheString

Using substring allows for the possibility that there are double-quote characters within the string as well as surrounding it.