I was trying to find out how to define my own delimiter (like a : or ; depending on which
one is not in the data itself) but no luck.
I'll login to a real windows machine with an EXCEL and try again.
b.t.w, space as a delimiter will need to face the same issue - the data might have spaces.
regards
ping
On 06/08/2012 10:24 AM, Erik Christiansen wrote:
On 08.06.12 09:45, ping wrote:I tried "save as" from excel into: format issue ======================================================================= csv (comma delimited) some of my data contains commaIf cell data contains cell delimiters, can the saved file even be re-imported into excel? i.e. It is corrupted data which is being saved, AIUI. The few spreadsheets I've encountered (long ago, admittedly) allow the cell delimiter to be set prior to saving the file. Can excel not do that? (It's what I've repeatedly done in similar circumstances ... well, actually asked others to do with their spreadsheets, before mining the data with text tools. ISTR tab being used instead of comma.)formatted text(space delimited) hard to alignAn aligning plugin was named on this list in the last week or so, ISTR. It might do the job?web page hard to render a framed pageThat does seem like the long way there. :-) Erik
No comments:
Post a Comment