Shell Programming and Scripting

@Franklin52
I already saw that the fieldseparator was missing...

But, even if I use the fieldseparator, there's still the probleme which i tried to translate. It seems that there's a problem with the date syntax, or something like that.

BTW:
If I write this at the commandline

echo "1265911223 www.google.com"|awk '{str="date -d @"$1; print system(str)}'
this is the result

Code:

Do 11. Feb 19:00:23 CET 2010
0

@pludi

Hey pludi,

also an interesting way. But also in your example there's a problem modifying the date. If I try your code, the result is this

Code:

date: ungültiges Datum „@126364422;http://www.google.de/“

date: ungültiges Datum „@126364535;http://www.google.de/“

date: ungültiges Datum „@126364535;http://www.google.de/#hl=de&source=hp&q=unix+forum&btnG=Google-Suche&meta=&aq=f&oq=unix+forum&fp=749e75dee4f1c52f“

date: ungültiges Datum „@126364536;https://www.unix.com/“

date: ungültiges Datum „@126364538;https://www.unix.com/shell-programming-scripting/“

date: ungültiges Datum „@126364547;http://www.google.de/“

date: ungültiges Datum „@126364556;http://www.google.de/“

By the way. It seems that you know the firefox databases. Do you know where exactly the visit date is stored. I've searched a long time, but I didn't get the right answer. In my moz_places in places.sqlite is a value called last_visit_date. In your example, you used the visit_date from the moz_historyvisit table. Is there an difference between these two values? The problem is, that I didn't found any information about last_visit_date at all, but I found information about the value you used (visit_date in moz_historyvisit). If yours is the right one, I would prefer your way to extract the date and URL...

Unfortunely I can't test it out at the moment without the GNU date....

I'll take a look again if you don't have the solution till tonight (EU).

It's important to define a single space as a separator in SQLite, as that's the easiest way to use it with the while read-loop. If you need a different separator, add it in the echo instead.

And no, I don't really know the databases, I just used a table that seemed right. Better check if the values you get are/could be correct.

@Franklin52

Hey Franklin,

thanks for your help. I found the mistake... In your post, there's a blank between @ "substr($10,1,10), so the timestamp did not stand right behind the @-Symbol... Again, thanks for your help...

@pludi

I also wanna thank you, maybe I can use your version somehow...

I couldn't test the command, but glad to know you get it working now.

Regards