DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Large .csv files

 
Post new topic   Reply to topic    DPlot Forum Index -> General discussion
View previous topic :: View next topic  
Author Message
Phillip Mathis



Joined: 10 Dec 2009
Posts: 21

PostPosted: Mon Jul 08, 2013 2:59 pm    Post subject: Large .csv files Reply with quote

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
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Mon Jul 08, 2013 6:36 pm    Post subject: Reply with quote

My best suggestion is to tell them to stop doing that Smile

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
View user's profile Send private message Send e-mail Visit poster's website
jsc



Joined: 02 Dec 2005
Posts: 222

PostPosted: Wed Jul 10, 2013 7:39 am    Post subject: Reply with quote

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
View user's profile Send private message
Phillip Mathis



Joined: 10 Dec 2009
Posts: 21

PostPosted: Wed Jul 24, 2013 1:18 pm    Post subject: Reply with quote

I wish that I had that kind of power Sad

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> General discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group