[Wactclc-alma] Quick way to concatenate a column of barcodes to use in Analytics filter

[Guidry, Wade]

In addition to Excel, you can do an analogous trick in Word.

Copy the column of barcode numbers from Excel, and paste into Word as 'text only'.

Then do a replace all, and replace ^p with ;

That will replace paragraph marks with semicolon.

Then you can copy and paste the resulting delimited barcodes into analytics as a filter.


Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org


From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Paula Laine via Wactclc-alma
Sent: Friday, January 4, 2019 4:38 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Cc: Paula Laine <plaine at bellevuecollege.edu>
Subject: Re: [Wactclc-alma] Quick way to concatenate a column of barcodes to use in Analytics filter

ATTENTION: This email contains links. Please follow best practices before clicking on links
There is a better way further down the page link for those who have  Office 365.
A new(?)  function called TEXTJOIN

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade via Wactclc-alma
Sent: Friday, January 4, 2019 4:34 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Cc: Guidry, Wade <WadeG at bigbend.edu<mailto:WadeG at bigbend.edu>>
Subject: Re: [Wactclc-alma] Quick way to concatenate a column of barcodes to use in Analytics filter

Paula,

Regarding this:

"We can no longer create a table of barcodes to query against."

Are you referring to something that you could previously do in analytics, but no longer?

Or are you talking about something you used to do in Voyager?


Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org


From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Paula Laine via Wactclc-alma
Sent: Friday, January 4, 2019 1:37 PM
To: wactclc-alma (wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>) <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Cc: Paula Laine <plaine at bellevuecollege.edu<mailto:plaine at bellevuecollege.edu>>
Subject: [Wactclc-alma] Quick way to concatenate a column of barcodes to use in Analytics filter

ATTENTION: This email contains links. Please follow best practices before clicking on links
I just googled something that may be old news to some of you but I'm going to share just in case.

We can no longer create a table of barcodes to query against. The workaround is to create a file of barcode numbers separated by semicolons and have it all in one field so it can be copied and pasted into a filter.

>From this:

[cid:image001.png at 01D4A44B.D4116800]

To this: 38230004724976;38230005049001;38230005068795;38230005088272;38230005088280;38230005088298;38230005115760;38230005115778;

I found an answer here: https://trumpexcel.com/concatenate-excel-ranges/

(Instead of a space between the quotes, put a semicolon.)

[cid:image002.png at 01D4A44B.D4116800]

Paula @ Bellevue College
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190105/0df36411/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 2368 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190105/0df36411/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 27652 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190105/0df36411/attachment-0005.png>