Page 1 of 1

Table output to csv format

Posted: August 23rd, 2017, 2:55 am
by Darwin13
Can I use the pff file to save the tabulation output as csv file format?

Like this?

[Run Information]
Version=CSPro 6.1
AppType=Tabulation
Operation=All

[Files]
Application=.\PPSnew6.xtb
InputData=.\P2810Y15WX.SRT
OutputTBW=.\PPSnew6.xtb.tbw
Listing=.\PPSnew6.xtb.lst

[UserFiles]
SAVEFILE=.\PPSnew6.csv


[Parameters]
ViewListing=OnError
ViewResults=No

Re: Table output to csv format

Posted: August 23rd, 2017, 7:32 am
by josh
No. You can't save tables as CSV. You can copy and paste them into Excel or save as tab delimited and import that into Excel and then save as CSV from Excel.

You can also use Export Data tool to save the data itself as CSV but not the tables.

Re: Table output to csv format

Posted: August 23rd, 2017, 9:43 pm
by Darwin13
Thanks for the reply Sir, that's what i'm doing, saving the table as tab delimited.
What I want to know is if I could bypass the clicking of the save table button and just run the pff file and it will automatically save the table as tab delimited.
What I'm currently doing now is creating a batch edit program to make the tables and write them to a txt file and run a macro program to convert all those txt file into excel format.

Re: Table output to csv format

Posted: August 24th, 2017, 7:25 am
by josh
Unfortunately there is no way to automate saving the tables in a different format using the pff file.

You can use table viewer from the command line to convert from a .tbw file to tab delimited. The syntax is like:

"c:\Program Files (x86)\CSPro 7.0\TblView.exe" "C:\Users\josh\Documents\CSPro\Examples 7.0\3 - Tabulation\Adding Weights\Weighted Tables.xtb.tbw" /EXPT /TABDELIM mytabdelimfile.txt

Re: Table output to csv format

Posted: August 25th, 2017, 1:59 am
by Darwin13
Thank you so much, this is perfect!!!

Re: Table output to csv format

Posted: September 24th, 2017, 10:30 am
by manishcspro
Method to write csvfile so that value of each valuset goes in a seperate column rather creating another row in multiple occurence records in cpro filerwrite logic...

Re: Table output to csv format

Posted: September 26th, 2017, 1:34 am
by Darwin13
Hi Josh, the command line works well with only one table.
Is there a way i can select a specific table if i have more than one table in my tabulation?
And maybe saving all the tables in my tabulation in CSV format?

Re: Table output to csv format

Posted: September 26th, 2017, 2:01 am
by josh
Unfortunately that command only exports the first table. It doesn't handle files that contain more than one table.

Re: Table output to csv format

Posted: September 27th, 2017, 5:04 am
by Darwin13
I see, thanks josh.