CSV file to be saved with tab separator value

divyasivathanu — Fri, 22 Jan 2021 05:07:24 GMT

Hi,

I need a CSV file to be saved with tab separator value. But I am not getting the expected result instead the value is getting replaced with '\t' as text.

Please find the code below and let me know what should be corrected.

SUB ExportChartToCSV

SET objChart = ActiveDocument.GetSheetObject("SAMPLE_ORDER")

objChart.Export "C:\Output\Inventory Manager\Data.CSV", "\t"

END SUB

Re: CSV file to be saved with tab separator value

Frank_Hartmann — Fri, 22 Jan 2021 11:19:50 GMT

try this:

SUB ExportChartToCSV SET objChart = ActiveDocument.GetSheetObject("SAMPLE_ORDER") objChart.Export "C:\Output\Inventory Manager\Data.CSV", Chr(9) END SUB

topic Re: CSV file to be saved with tab separator value in QlikView

CSV file to be saved with tab separator value

Re: CSV file to be saved with tab separator value