MCCC Knowledge Base

Creating a formatted List of IDs for Use in a CROA Filter

2017

Creating a formatted List of IDs for Use in a CROA Filter

 

When you want to select a specific set of IDs in CROA, they must be formatted with a ‘;’ between the IDs in the list. Here are the steps to get the list into that format.

These instructions assume you have already exported a list of ID numbers from Colleague

 

1. Open the Excel grid and highlight the column of ids you want to use in your CROA report.  
2. Select and Copy the ID numbers  
3. Open a blank Word document  

4. Right click in the body of the blank document a do a “Paste”, selecting the “Keep Text Only” option.

If there were any headers, column sum or counts, delete them from the document. Your document should look something like this:

 

5. Click   from the Home tab of the Ribbon to find all paragraph marks and replace with ;
  • Find what = ^p
  • Replace with = ;
 
6. Click Replace All
  • Your document should now look like this:
 
7. Select All (Ctrl+A)  
8. Copy (Ctrl+C)  
9. Open the appropriate report in CROA  
10. Paste the copied IDs into the report query filter or filter prompt  
   
0 (0)
Article Rating (No Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
CROA - Viewing Web Intelligence documents
Viewed 8292 times since Thu, Jul 9, 2015
Advisory Committee Membership Reporting
Viewed 7293 times since Thu, Jul 16, 2015
CROA - How to change the report title and name
Viewed 8343 times since Wed, Jul 8, 2015
CROA - How to customize a table in the report
Viewed 7528 times since Wed, Jul 8, 2015
CROA BI launch Pad 4.x Tutorials
Viewed 9411 times since Thu, Jul 9, 2015
CROA - To change the page layout
Viewed 6820 times since Wed, Jul 8, 2015
CROA Video tutorials
Viewed 9695 times since Thu, Jul 9, 2015
CROA - Viewing objects
Viewed 7874 times since Thu, Jul 9, 2015
CROA - Working with content objects
Viewed 8717 times since Thu, Jul 9, 2015
CROA - To save the document in PDF format
Viewed 6734 times since Wed, Jul 8, 2015

Need Help?