Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
Hi Thom,
You can use the PurgeChar function to remove characters that may or may not be there:
PurgeChar(MyField, Chr(34))
Stephen
Hi Thom,
You can use the PurgeChar function to remove characters that may or may not be there:
PurgeChar(MyField, Chr(34))
Stephen
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 ' '
Thanks Stephen it worked perfect. Have a great day.....I know I will now.
Thom
Thanks...Thom