WORKS TITLE_DISPLAY and publisher display
Something I've always been curious about.
The TITLE_DISPLAY and PUBR_DISPLAY in the WORKS table have (for us at least) always contained a ". - " (period space hash space) in front of the the title or publisher.
I've included a snip of perl and sample output to demonstrate.
First of all, do other Talis sites have the same? or is this a 'Sussex thing'?
If the former, why is it held in this way?
Just curious.
(@results) = &sql($d,"
SELECT CONTROL_NUMBER, TITLE_DISPLAY, PUBR_DISPLAY
FROM WORKS
");
foreach $resultline(@results) {
($control, $title, $pub) = split('~', $resultline);
print "Control: $control \nTitle: $title\nPublisher:$pub\n\n";
}
Control: M0482752US
Title: . - Experimental film and video : an anthology / edited by Jackie Hatfield ; pic
Publisher:. - Eastleigh, UK : John Libbey Pub.; Bloomington, IN : Distributed in North Ame
Control: 1843105896
Title: . - Children and spirituality : searching for meaning and connectedness / Brenda
Publisher:. - London : Jessica Kingsley
Control: 184720211x
Title: . - Diversity in the knowledge economy and society : heterogeneity, innovation a
Publisher:. - Cheltenham, UK; Northampton, MA : Edward Elgar
Control: 1845429265
Title: . - International handbook of entrepreneurship and HRM / edited by Rowena Barret
Publisher:. - Cheltenham : Edward Elgar
Cheers
Chris
Removing characters from the start of TITLE_DISPLAY
It is common for all customers. You are not alone. As to why I'm not sure but it has always been thus. I think it is related to separating components when building the complete works display.
To get rid of them try changing the SQL to
SELECT CONTROL_NUMBER, substring(TITLE_DISPLAY,5,80),substring(PUBR_DISPLAY,5,80)
FROM WORKS
This will show the values from the fifth character to the eightieth which will cut off the prefix characters. You could increase the end point if you want.
You could do the same in perl itself but it as easy to modify the SQL in this case.
Thanks
Brian Crampton
Developer, Talis
That's a good tip, I've only
That's a good tip, I've only ever removed them in perl. Thanks
Glad to hear it isn't a Sussex thing :)
Chris Keene - University of Sussex.