Make XY Event Layer - need to convert to tab delimited csv file?

Discussion created by mustol on Mar 3, 2011
Latest reply on Mar 7, 2011 by kimo
I have a very large csv file (too large to load in excel). If you take a section of the data and load it in excel, strings all load into one column, seperated by spaces. I need to create XY Event Layers from this csv and it appears for this to work that the csv needs to be tab delimited. I've tried to write a Python script replacing spaces with '\t' or using the csv module but cannot get it to work - my scripting knowledge is limited. Does anyone have a script to do this or can point me in the right direction? Any help would be much appreciated.