.csv files

fjkaykr11
fjkaykr11 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
Test your restores, not your backups...
Top Expert 2016
Commented:
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
Gerwin Jansen, EE MVETopic Advisor
Most Valuable Expert 2016
Commented:
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.

Author

Commented:
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

Author

Commented:
Thanks again for all the help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial