Thought I would add a couple of items to the growing list of things we know ;)
Steph
Converting Column of IDs
- Open Notepad ++
- Copy and paste column of data into Notepad ++
- Search > Replace
- Enter in the fields (this will add a single quote comma single quote between every item)
Find What: (\h*\R)+
Replace with = ','
- Add left parentheses and single quote at beginning of string and single quote and right parentheses at end of string
- If you add the ANY command to a query a simple copy and paste can be done of the data above.
------------------------------
Steph Zimmerman
IT Tech Associate
Illinois State University
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------