Solved

.csv files

Posted on 2016-09-11
5
92 Views
Last Modified: 2016-09-12
I am working with a large .csv file (about 8 gigs) that I exported from a database.  When I try to open using CSV edit, I get an error "file is empty".   Does anyone know if there is a maximum number of rows / fields for .csv files and other tools I can use to trouble shoot why I am getting this error.  Thanks for any info.
0
Comment
Question by:fjkaykr11
5 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 125 total points
ID: 41793791
I use Akelpad editor for large files, but it is not very convenient (very slow). I would suggest to split large csv file into parts with few strings of code.
0
 
LVL 53

Accepted Solution

by:
Bill Prew earned 250 total points
ID: 41793999
What tool specifically do you mean by "CSV editor"?  Is it this, or something else?

http://csved.sjfrancke.nl/

CSV files do not have a maximum size limitation on their own, they can be any size in theory.  The limits typically occur in the programs that open and parse them, which you could be running into.  Or your file maybe be malformed and therefore not being handled properly by the utility program you are using.

I would suggest providing a little more detail here, such as:

- Are you working on Windows?
- What is the specific tool and version you are using?
- Can you upload a sample of the CSV file, probably in a ZIP file to save space.
- What are you trying to do with the file once open, just view, or extract data, or update, etc?

~bp
0
 
LVL 37

Assisted Solution

by:Gerwin Jansen
Gerwin Jansen earned 125 total points
ID: 41795084
What is it you want to do with that file?

Are you on Windows Linux platform?

vim or notepad++ is what I would try.

@bp - I've placed my previous comment again, now without Gig suggestion which was not what I meant.
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 41795152
Sorry for the slow response, I can't login during day  to post further info.  Here is an update on my question that i think is resolved. I am using Windows platform.   I have Notepad++ but I got an error when trying use this (file too large), I am also using CSVed.   I realized hours after I posted the question that I think I had the wrong selection in CSVed (to answer what specific app I am using), I had to change from Comma to Pipe as that is what I used as a delimiter (sorry I didn't realize sooner, I just don't use the tool often, and typically I am using Comma delimited files when I do.   Once selected pipe I was able to open the file and view the data.
However, to make it easier to work with I split it into multiple files using a VBS script I got from someone on EE.  Now I can open with Excel and format the data as needed.  Thanks for all the help
0
 
LVL 3

Author Closing Comment

by:fjkaykr11
ID: 41795153
Thanks again for all the help.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Question about consuming GB from Comcast 5 53
Batch/VBScript : Disable Windows tasks 7 34
Question about DB Schema 27 50
Merging spreadsheets 8 29
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now