topic Re: export work but delimiter not in QlikView

export work but delimiter not

Tue, 23 Sep 2014 09:44:31 GMT

i do a macro

export work fine with delimet ";" but i need not delimiter "" (no spaces)

if i put "" or chr(0) it give me a TAB delimiter.

someone can help?

this is the macro

SET objSheetObject = ActiveDocument.GetSheetObject("CH01")

objSheetObject.ServerSideExportEx v_name, chr(0),1

Re: export work but delimiter not

Wed, 24 Sep 2014 16:57:29 GMT

someone can help with this?

Re: export work but delimiter not

Thu, 25 Sep 2014 06:54:03 GMT

help

Re: export work but delimiter not

varunjain — Thu, 25 Sep 2014 06:58:40 GMT

DID YOU TRY THIS?

set obj1=ActiveDocument.GetSheetObject("CH05")

obj1.Export Path&"ABC.csv" , ""

Re: export work but delimiter not

Thu, 25 Sep 2014 08:36:01 GMT

it gives me ["data"], " first and last caracter.

Not work.

Any idea?

Re: export work but delimiter not

varunjain — Thu, 25 Sep 2014 09:47:24 GMT

Whats exactly is your delimniter?

Re: export work but delimiter not

Thu, 25 Sep 2014 10:18:54 GMT

i don´t need delemiter.

expected result

AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAA

now give me

"AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAA"

Regards

Re: export work but delimiter not

varunjain — Thu, 25 Sep 2014 10:24:50 GMT

TRY THIS

sub ExportToCSV()

path="E:\ABC\"

set obj1=ActiveDocument.GetSheetObject("CH05")

obj1.Export Path&"ABC.csv"

end sub

Re: export work but delimiter not

varunjain — Thu, 25 Sep 2014 10:28:08 GMT

THIS IS WORKING FINE FOR ME

sub ExportToCSV()

path="F:\ABC\"

set obj1=ActiveDocument.GetSheetObject("CH05")

obj1.Export Path&"ABC.csv",""

end sub