topic Export ListBox without quotes in QlikView

Export ListBox without quotes

Thu, 26 Jul 2012 20:41:28 GMT

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.-

Re: Export ListBox without quotes

Anonymous — Fri, 27 Jul 2012 01:34:03 GMT

You could use something like:

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

Re: Export ListBox without quotes

Fri, 27 Jul 2012 12:25:15 GMT

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.-