Eliminating the double quotes

[tmumaw]

Is there a way to eliminate the double quotes? It appears some of the fields stored in our sql db are defined a text. Thanks

example "3308774875"

[stephencredmond · Accepted solution]

Hi Thom,

You can use the PurgeChar function to remove characters that may or may not be there:

PurgeChar(MyField, Chr(34))

Stephen

[deepakk]

hi Thom,

try using replace function.

eg:

trim(replace(fieldname, '"',' '))

first parameter takes the fieldname , second parameter the character to be replace ,it should be between single quotes ' " '. third parameter is the new character, here it will be blank or space like ' '

[tmumaw]

Thanks Stephen it worked perfect. Have a great day.....I know I will now.

Thom

[tmumaw]

Thanks...Thom