On Fri, 11 Feb 2005 16:10:59 -0700
"Andreas J. Guelzow" <[EMAIL PROTECTED]> wrote:
> On Fri, 2005-11-02 at 23:30 +0100, Nomine Mutato wrote:
> > Hi to all. I tried to build a simple analysis system for CSV report
> > by Google AdSense, but Gnumeric said that it can't import this file
> > because is unknow format.
> >
> > If I do ~$ file report.csv from command line /bin/file said:
> > "report.csv: MPEG ADTS, layer I, v1, 96 kBits, 44.1 kHz, Stereo"
> >
> > I tried to ~$ cat report.csv | awk '{print $1,$2,$n...}' >
> > myreport.csv, but myreport.csv is same file of report.csv. It's a
> > binary file!
> >
> > If I do ~$ strings report.csv result is an empty file!
> >
> > Can you help me? I can't share my CVS file report, because Google
> > policy about it forbids that, but if want I can edit this by hand
> > with non true data, and attach this onto mail message.
> >
>
> Hi,
>
> CSV files (comma separated values) are text files. If you look into
> the file using cat or less or more you should see straight text. If
> you don't then your file is _not_ a csv file.
Google said it's a CSV file... OOo Calc open correctly this
file... I suppose it is a "CSV from Microzoz" or similar way.
I had encode head of this file with no true data:
-- cut starts below this line --
begin-base64 644 google-report
//4wADEALwAwADEALwAwADUACQAzADkAMAAJADgACQAiADAALAA0ACUAIgAJ
ACIAMAAsADMAMgAiAAkAIgAwACwAMQAyACIACgAwADIALwAwADEALwAwADUA
CQA2ADMANAAJADEAOAAJACIAMQAsADEAJQAiAAkAIgAwACwAOQA4ACIACQAi
ADAALAA1ADgAIgAKADAAMwAvADAAMQAvADAANQAJADkANAA1AAkAMQAJACIA
MAAsADEAJQAiAAkAIgAzACwAOQA4ACIACQAiADEALAA4ADcAIgAKADAAMQAv
ADAAMQAvADAANQAJADMAOQAwAAkAOAAJACIAMAAsADQAJQAiAAkAIgAwACwA
MwAyACIACQAiADAALAAxADIAIgAKADAAMgAvADAAMQAvADAANQAJADYAMwA0
AAkAMQA4AAkAIgAxACwAMQAlACIACQAiADAALAA5ADgAIgAJACIAMAAsADUA
OAAiAAoAMAAzAC8AMAAxAC8AMAA1AAkAOQA0ADUACQAxAAkAIgAwACwAMQAl
ACIACQAiADMALAA5ADgAIgAJACIAMQAsADgANwAiAAoAMAAxAC8AMAAxAC8A
MAA1AAkAMwA5ADAACQA4AAkAIgAwACwANAAlACIACQAiADAALAAzADIAIgAJ
ACIAMAAsADEAMgAiAAoAMAAyAC8AMAAxAC8AMAA1AAkANgAzADQACQAxADgA
CQAiADEALAAxACUAIgAJACIAMAAsADkAOAAiAAkAIgAwACwANQA4ACIACgA=
====
-- cut end above this line --
Cut and paste this code into your file named report.uu, and then try
from command line
~$ uudeconde -o report.csv report.uu
~$ file report.csv
and look result. You can read this file with cat and less, but it is a
binary file!
See too: uuencode(5) uudecode(5).
Hi!
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
