Community Platform

Knowledgebase

Documents, videos, websites and more.

Excel Tip: Converting a list of EINs into a MySQL filter for use on the Dataweb

Brief description or abstract:

Start by copying a list of records from the Search Tool into Excel.  (This may be the only tool available to generate a list of EINs by, say, distance from a location.)

This sample spreadsheet has 3 columns in red added to create the EIN list.  It looks like the newer version of Excel handles the copying a bit differently than the old with the blank spaces on either side of the EINs. Thus, the first column strips those out.  The 2nd adds a leading "0" -- probably not necessary with new versions of Excel -- for EINs that began with zero but lost it in the copying.  The final column adds the quotes and commas.

\\\\\\\\UI1\\\\VOL1\\\\CENTERS\\\\CNP\\\\TPOLLAK\\\\prgs\\\\KEY\\\\fixEinList.xlsx

 

NOTE: Make this entry public once file is attached on new server. (TOM)

Posting type(s):
Links & Files
URL:
Regions & Topics
Geographic regions: United States
Topic(s):
Subtopic(s):
Number of "Likes":0
Number of Views:187
Posting Details
Publication date: 0000-00-00
Tags
Tags:
Added 2011-08-03 by tpollak, Modified 2011-09-27 by kuttkeUI

Comments

No comments.