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
Table output to csv format
Re: Table output to csv format
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.
You can also use Export Data tool to save the data itself as CSV but not the tables.
Re: Table output to csv format
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.
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
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
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
Thank you so much, this is perfect!!!
-
- Posts: 67
- Joined: June 26th, 2017, 2:15 pm
Re: Table output to csv format
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
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?
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
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
I see, thanks josh.