View Single Post
Old 10-08-2014, 02:02 PM   #6
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,141
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by millan View Post
on the Spreadsheet output, I get long pubdate like:

Code:
'2014-03-04T00:00:00+02:00
'2003-05-13T00:00:00+03:00
and I'd like to have like:
Code:
2014
2003
since I have more than few hundred book/articles list and growing every so often which also means I update the catalog output so often, I need a permanent solution if possible in the output file which I then save .xls as html and search the contents via that html file
you must be using the CSV output of the Catalog out.
That is a 'timestamp' format

You will probably have to clean it up using the substring function of your spreadsheet.
theducks is offline   Reply With Quote