On 09/15/2012 06:17 AM, andy pugh wrote: > That is what CSV is, "comma separated variables". The special > character is a comma. > It is also a really bad choice, as a large proportion of the world use > the comma as a decimals separator. I used to think it meant "comma separated values", and I think that makes sense, except that somebody already thought of the usefulness of the comma in data. I just imported something like this file:
fname:lname:stuff:number erastmus b.:dragging:techie:29 budd:tugly:makeup artist:22 into Libre Office Calc and the import feature allows a radio button choice of comma, semi-colon, and a few others, but allows you to choose practically ANY character you want to be the separator. It wants to have text surrounded by either single or double quote characters. I did a copy of the file with the colon replaced by the underscore character, and it imported fine also. While you could use Libre Office to import the CSV file, and write it out to an XLS file, I suspect that is not necessary. While I don't have a copy of Excel here to try it out, I suspect it allows semi-colon as a separator, and perhaps any other character. We have imported CSV files at work in the past. Someone wrote an app that takes data from our tester and writes it out as a CSV. We have an Excel spreadsheet that takes that data, and puts it into a nice, formatted data sheet we can send to customers. This probably comes under the heading of Just Works (tm). 8-) ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ Emc-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/emc-users
