Export ListBox without quotes

[#1]

Hi all. I'm exporting a List Box into a txt file using a macro like this:

function ServerExportEx

          Set st = ActiveDocument.GetSheetObject("LB35")

          st.ServerSideExportEx "C:\FTP\Clientes\"&"MAILS"&".TXT",";",1

end function

The exported data are email addresses, so at the end of each field i added a (;) to separate addresses.

The problem is that each field contains a quotes at beggining and at the end. Like this:

"address1@company1.com;"

"address2@company2.com;"

"address3@company3.com;"

"address4@company4.com;"

Anyone know how to do to export data from a List Box without the quotes?.

Thank you very much.

Luciano.-

[Anonymous]

You could use something like:

ActiveDocument.Evaluate(PurgeChart(STRING, '"')) in your macro, where string is the mail address.

[#3]

Hi, thanks for your reply. The problem with this function is that the mail adresses are in an object and PurgeChar() only accept a string char as parameter. Second, the single quotes become a comment line, so i used the function like this way:

PurgeChar(STRING, 'Chr(34)')

But I do not work that way.

Thank you very much. Regards.

Luciano.-