Remove unwanted characters

[stekol61]

Hi!

I'm loading an object from a database with names that start and ends with "

What is the best way to remove ". E.g "altea" -> altea

In the extract script or in the application?

[sunny_talwar]

May be try this

PurgeChar(Conv_Client, Chr(34)) as Conv_Client

[sunny_talwar]

Or use Replace

Replace(Conv_Client, Chr(34), '') as Conv_Client