Monthly Archives: November 2015

A quick list-to-array conversion trick

Somebody sends you an Excel spreadsheet with a bunch of OBS terms on it. Could be patient PIds, could be anything – it’s a big list. You want to use that list in a query, and there could be dozens or hundreds of them. Options are to set up a data connection to the spreadsheet, or paste the list into your query and start adding single quotes and commas. Or, you can copy this little bit of code and put it in your tricks file: Continue reading