View previous topic :: View next topic |
Author |
Message |
Phillip Mathis
Joined: 10 Dec 2009 Posts: 21
|
Posted: Mon Jul 08, 2013 2:59 pm Post subject: Large .csv files |
|
|
All,
Once again, the powers that be are dumping more and more data (1500 columns) into a .csv file. As you are aware, Excel cannot handle this much data. I only use a fraction of the data for analysis, but some of the information is past the 256th column.
Does anyone have any suggested programs that will allow me to sift out columns of data without corrupting the original file? |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Mon Jul 08, 2013 6:36 pm Post subject: |
|
|
My best suggestion is to tell them to stop doing that
But a better suggestion might be to update Excel. Excel 2010 will work with 1,048,576 rows by 16,384 columns. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
jsc
Joined: 02 Dec 2005 Posts: 222
|
Posted: Wed Jul 10, 2013 7:39 am Post subject: |
|
|
Not sure about this, but CSVFileView from Nirsoft might help you open the file, cut some columns, then resave what you need. From the developer, when I asked how many columns it could handle, "There is no official limitation for number of columns in CSVFileView. It depends on the 'ListView' control of Windows that is used to display the csv data."
Nirsoft is at www dot nirsoft dot net. |
|
Back to top |
|
|
Phillip Mathis
Joined: 10 Dec 2009 Posts: 21
|
Posted: Wed Jul 24, 2013 1:18 pm Post subject: |
|
|
I wish that I had that kind of power
They add sophisticated equipment to reduce operator workload, then add more equipment to increase capability. What happed to just aim and shoot.
jsc, I appreciate yor assitance. I will look at the link to see if it fits our needs. |
|
Back to top |
|
|
|