Re: [IUG] exporting with URL for Serials Solutions

[VT Library Webmaster <libinst at vt dot edu>]

> Welcome to the Serials Solutions group. Create a list of all your
> journal records and export the bib numbers. In Excel, add your catalog
> url/record= and you'll end up with a column of url's such as this
> http://simon.ups.edu/record=b1174059. Of course if you use Ezproxy
> you'll need to add that in too.

You'll probably need to lop off the check digit (my URLs don't work with it).

I use the Excel function LEFT

LEFT (Cell,NumberOfCharacters)  like LEFT(A2,8)

then CONCATENATE

CONCATENATE("http://simon.ups.edu/record=",LEFT(A2,8))


--
Robert Sebek
Webmaster, University Libraries, Virginia Tech
http://www.lib.vt.edu
(540) 231-1849