Quote:
Originally Posted by millan
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:
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.