Getting ISBNs and titles for JSTOR DDA

[Paul Poulain]

Le 27/03/2014 12:22, Cockerill, Alan a écrit :
>>             Can anyone suggest a way to get the Koha report of
>>             concatenated ISBNs to translate into one ISBN per column? 
Hi Stacy,

(I almost missed this thread, "Koha" is not written in the title...)

If I understand correctly, you get concatenated ISBN like
3453459018|0980989823|04980989081 in biblioitems.isbn  field, right ?

What about replacing | by something that can be interpreted as a <CR> ?
You have the REPLACE mysql function :
https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace

Something like
SELECT REPLACE(biblioitems.isbn,'|',CONCAT(CHAR(10),CHAR(13))) FROM
biblioitems.isbn
could be useful ?

Good luck

-- 
Paul POULAIN - BibLibre
http://www.biblibre.com
Free & Open Source Softwares for libraries
Koha, Drupal, Piwik, Jasper

============================

To unsubscribe: http://bit.ly/web4lib

Web4Lib Web Site: http://web4lib.org/

2014-03-27