Forum Home
Press F1
Thread ID: 99653	2009-05-10 00:10:00	handling csv files	piva (3796)	Press F1

Post ID	Timestamp	Content	User
772647	2009-05-11 12:59:00	I offered to do a regex conversion for him/her, but apparantly it's not just a one-off - and my scripts aren't usually very user-friendly for use on Windows, so they still need a solution! Maybe an Excel guru could write a macro which would do it? I'm a little out of practice with my VBA, otherwise I'd give it a go.	somebody (208)
772648	2009-05-11 20:12:00	I'm not sure what gives here. If piva wants eight fields across then the entries would not be imported into any more than eight columns. This would not run into the 250 column limit. It may be that the file is so large that it may run into a limit on rows but that is a different story. The row limit in Excel 2000 and 2003 is 65,536 rows. In my opinion we need more info. Possibly Excel 2007 may handle it if I'm wrong:- Info here office.microsoft.com How to do it in Excel 2007 www.howtogeek.com Put in a column break at the eighth column and the text will flow down the rows. Possibly it may be done using ealier versions of Excel but I have not tried it.	Sweep (90)
1 2