Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

export work but delimiter not

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

8 Replies
Not applicable
Author

someone can help with this?

Not applicable
Author

help

varunjain
Creator
Creator

DID YOU TRY THIS?

set obj1=ActiveDocument.GetSheetObject("CH05")

obj1.Export Path&"ABC.csv" , ""
Not applicable
Author

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

Not work.

Any idea?

varunjain
Creator
Creator

Whats exactly is your delimniter?

Not applicable
Author

i don´t need delemiter.

expected result

AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAA

now give me

"AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAA"

Regards

varunjain
Creator
Creator

TRY THIS

sub ExportToCSV()

path="E:\ABC\"

  set obj1=ActiveDocument.GetSheetObject("CH05")

  obj1.Export Path&"ABC.csv"

end sub

varunjain
Creator
Creator

THIS IS WORKING FINE FOR ME

sub ExportToCSV()

path="F:\ABC\"

  set obj1=ActiveDocument.GetSheetObject("CH05")

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

end sub