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

Mon Jan 7 07:52:10 PST 2019

Analytics will do this for you now; if you have a column of barcodes (or MMS IDs or whatever), when you edit the filter, if you click the binoculars next to Value, then click the 'edit' pencil in the corner above the 'Selected' box, you can simply paste the column in there; hit ok there and on the next dialogue box to get back to the filter and it will have put them all on a line and added the semicolons for you.

Hannah Micona

Cataloger, Holman Library

Green River College

(243) 833-9111 ex. 2098

________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> on behalf of Guidry, Wade via Wactclc-alma <wactclc-alma at lists.ctc.edu>
Sent: Friday, January 4, 2019 5:40:45 PM
To: WACTCLC Alma Discussion
Cc: Guidry, Wade
Subject: Re: [Wactclc-alma] Quick way to concatenate a column of barcodes to use in Analytics filter

CAUTION: This email originated from outside of Green River College. Please do not click any links or open attachments unless you know the sender and know the information is safe. Even if you know the sender, if the request or information seems unusual please check with the sender first before clicking a link or opening the attachment. If you are unsure, contact the IT Help Desk at x2222 or email ithelpdesk at greenriver.edu<mailto:ithelpdesk at greenriver.edu>.

Please do not give out or enter your Green River email, network login, password information on non-Green River websites.

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<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org&data=02%7C01%7Chmicona%40greenriver.edu%7Cd7b6bc273e954850636e08d672aeda24%7Cfa40663e972749789bce776cf824bca5%7C1%7C0%7C636822492642272389&sdata=cHr84kaLR%2BOC9TSX7PzHSXoDA4MS7U7CPTDLaHlOe5Y%3D&reserved=0>

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<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org&data=02%7C01%7Chmicona%40greenriver.edu%7Cd7b6bc273e954850636e08d672aeda24%7Cfa40663e972749789bce776cf824bca5%7C1%7C0%7C636822492642282393&sdata=qX%2BdNnl6hdN8lJ2CnVgausTWkZ3rHnqe4ZySZqbaYPU%3D&reserved=0>

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/<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftrumpexcel.com%2Fconcatenate-excel-ranges%2F&data=02%7C01%7Chmicona%40greenriver.edu%7Cd7b6bc273e954850636e08d672aeda24%7Cfa40663e972749789bce776cf824bca5%7C1%7C0%7C636822492642282393&sdata=yIQ9cpc0%2B8eRowbmFsOoU%2FGltFHqp3LD0seF0Txv65I%3D&reserved=0>

(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/20190107/2e507e7c/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/20190107/2e507e7c/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/20190107/2e507e7c/attachment-0005.png>