Standard basic text programs like Notepad are okay, but Notepad++ is free, awesome, and offers bells and whistles that Notepad and others don't.

Download Notepad++ for free

[This is akin to the Make Table function using Access connected to your data tables back in the days of yore, in order to, for example, run a report of barcodes associated with a particular list of MMSIDs]

Convert a .txt of MMSIDs, barcodes, OCLC numbers, etc. one to a line (separated by carriage returns) to a continuous list separated by a space and a semicolon for use in an Alma Analytics filter:

• To view invisible characters like carriage returns and line breaks: View -->Show Symbol --> Show All Characters
• You want to replace CR and LF with a semicolon and a space

• Use the Replace function (Search --> Replace)
• Make sure to choose Extended in Search Mode
• Find what: \r\n (this finds CR and LF)
• Replace with: ; (make sure to type in a space)
• Replace All

The list has to start with a number (syntax: number semicolon space number semicolon space...), so delete your text header (Barcode) before pasting into the fllter

To paste into the filter in Analytics, Filter

Paste from Notepad++ and OK