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

[Paula Laine]

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 01D4A431.BB622070]

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 01D4A432.8DF91B60]

Paula @ Bellevue College
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 46883 bytes
Desc: not available
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190104/94ba20c6/attachment.bin>