Thundarfoot Posted January 27, 2008 Share Posted January 27, 2008 ok I have a large text file that I am converting into excel spreadsheet for eventual table in mysql. all I know about csv is that every , comma makes a new cell / field. is there a way to make a line break? For example... one entry, two entry, third entry, (line break) 4th entry, 5th entry, basically I want to make all entry's in my text file (currently sepoerated by , commas) become one column when I open in excel. hope that makes sense, I could go through the file and manually add a line break after every comma...but with 7000 lines with each line having about 18 commas.....ummm there goes my weekend Quote Link to comment Share on other sites More sharing options...
mattclements Posted January 31, 2008 Share Posted January 31, 2008 hmmm could you post a few lines of the text file, then post a rough idea of a way you want the spreadsheet to look, then I can help you... cheers matt Quote Link to comment Share on other sites More sharing options...
laffin Posted January 31, 2008 Share Posted January 31, 2008 CSV format is seperated by columns, one row per line Col1,Col2,Col3,Col4,Col5 if u want everything in Col1, than output yer data as mydata,,,, notice that i leave the , for the other columns you can skip columns as well, by doing the same thing, say we want data in col3 ,,mydata,, it's not all that hard Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.