Dialog
Dialog Support   >   "How Do I...?" Series   >   Business & Industry
Dialog "How Do I...?" - Business & Industry

Search Comprehensively on Company Names?

TOPIC: Searching on company names is not always the straight forward procedure that we’d like it to be. Initials, acronyms, personal names and punctuation rules can interfere with our ability to locate information on a company. This How Do I…? suggests various methods for getting the most comprehensive results.

1. Searching for company names that are personal names

These would include companies such as Charles Schwab, A. O. Smith, and A.G. Edwards. In our example, we’ll use A.G. Edwards, a division of Wachovia Securities. The examples have been run in the NEWSCO OneSearch® category, that contains news files with a Company Name (CO=) field. The technique would be the same in any file(s) with a CO= field. Not all company names that are personal names include initials, but the example shows perhaps the most challenging name you’re likely to encounter.

2. Searching for company names that contain hyphens or compound words

Company names that are hyphenated or that contain trademark symbols between two words are sometimes compressed to a single word. The simplest method for ensuring complete retrieval is to search the name as though it were one word as well as two (e.g., SELECT WALMART/CO OR WAL()MART/CO).

3. Searching for company names that contain or are solely acronyms or initials

Searching company names that contain or are solely acronyms or initials is similar to searching for personal names. Use the EXPAND command, making sure to try the variations for punctuation marks, no punctuation, spaces, and no spaces, (e.g., EXPAND all variations: IBP, I B P, IBP,).

4. Searching for companies with common names

Avoid searching common names as phrases. This would include all those popular terms like FIRST, NATIONAL, FEDERAL, AMERICAN, etc., For instance, SELECT FIRST (W)AMERICAN/CO retrieves: First American Bancorp, First American National Bank, First American Corp, First American Insurance, First American Real Estate, First American Title Co. EXPAND all the significant words of the company name on the Company Name (CO=) field.

 

COMMAND SUMMARY

BEGIN NEWSCO
EXPAND CO=A.G. EDWARDS
SELECT “E” REFERENCE NUMBERS
EXPAND CO=A. G. EDWARDS; SELECT E NUMBERS
EXPAND CO=AG EDWARDS; SELECT E NUMBERS
EXPAND CO=A G EDWARDS; SELECT E NUMBERS
EXPAND CO=EDWARDS, A; SELECT E NUMBERS
EXPAND CO=EDWARDS (A; SELECT E NUMBERS
DISPLAY SETS
SELECT S1:S6
SELECT S7/2007:2008


HOW TO...



1. BEGIN the OneSearch category NEWSCO.

Note: This methodology applies to any file that has a Company Name (/CO, CO=) or Patent Assignee (PA=) field.

 

 

2. EXPAND the company name on the Company Name (CO=) field using standard punctuation, spacing and word order.

3. SELECT fitting “E” Reference numbers.


?b newsco

SYSTEM:OS  - DIALOG OneSearch
  File   9:Business & Industry(R) Jul/1994-2007/Dec 20
         (c) 2007  The Gale Group
  File  15:ABI/Inform(R) 1971-2008/Jan 03
         (c) 2008 ProQuest Info&Learning
  File  16:Gale Group PROMT(R) 1990-2008/Dec 26
         (c) 2008 The Gale Group
. . . .
      Set  Items  Description
      ---  -----  -----------
?e co=a.g. edwards
Ref   Items  Index-term
E1       30 *CO=A.G. EDWARDS
E2       19  CO=A.G. EDWARDS & SONS
E3        4  CO=A.G. EDWARDS & SONS INC
E4      103  CO=A.G. EDWARDS & SONS INC.
E5        1  CO=A.G. EDWARDS & SONS INCORPORATED
E6        1  CO=A.G. EDWARDS & SONS U.K. LIMITED
E7       66  CO=A.G. EDWARDS & SONS, INC.
E8        1  CO=A.G. EDWARDS & SONS, INC.; A.G. EDWARDS, INC.
E9        1  CO=A.G. EDWARDS & SONS, INC.; CHECKFREE INVESTMEN
E10       1  CO=A.G. EDWARDS & SONS, INC.; J.D. POWER AND ASSO
E11      15  CO=A.G. EDWARDS AND SON INC.
E12       2  CO=A.G. EDWARDS AND SONS
E13    1062  CO=A.G. EDWARDS AND SONS INC.
E14       2  CO=A.G. EDWARDS AND SONS, INC.
E15       4  CO=A.G. EDWARDS CAPITAL INC.
E16     615  CO=A.G. EDWARDS INC.
E17      32  CO=A.G. EDWARDS INCORPORATED
E18       1  CO=A.G. EDWARDS MEDIA
E19       3  CO=A.G. EDWARDS MEDIA &
E20       1  CO=A.G. EDWARDS MEDIA AND ENTERTAINMENT CONFERENC
E21       1  CO=A.G. EDWARDS TRUST CO.
E22       1  CO=A.G. EDWARDS TRUST COMPANY
E23       1  CO=A.G. EDWARDS; CARMICHAEL LYNCH; INTERPUBLIC GR
E24      99  CO=A.G. EDWARDS, INC.
E25       1  CO=A.G. EDWARDS, INC.; A.G. EDWARDS & SONS, INC.
Enter P or PAGE for more

?s e1:e17, e21,e22,e24,e25             1852  CO=A.G. EDWARDS:CO=A.G. EDWARDS INCORPORATED                1  CO=A.G. EDWARDS TRUST CO.                1  CO=A.G. EDWARDS TRUST COMPANY               98  CO=A.G. EDWARDS, INC.                1  CO=A.G. EDWARDS, INC.; A.G. EDWARDS & SONS, INC.       S1    1949  E1:E17, E21, E22,E24, E25


4. EXPAND
with spacing after the periods. SELECT appropriate E numbers.

?e co=a. g. edwards

Ref   Items  Index-term
E1        3  CO=A. G. *EDWARDS & SONS
E2        2  CO=A. G. DAVIS GAGE & ENGINEERING CO.
E3        0 *CO=A. G. EDWARDS
E4        1  CO=A. G. PIPE LINES (CANADA) LTD.
E5        1  CO=A. GAASTRA BEHEERSMAATSCHAPPIJ B.V.
E6        8  CO=A. GARY SHILLING AND CO.
. . . .  

?s e1
S2 3 CO='A. G. *EDWARDS & SONS'



5. EXPAND
dropping the punctuation and the space between initials and SELECT E number(s).

?e co=ag edwards

Ref   Items  Index-term
E1        1  CO=AG EDUCATION & CONSULTING
E2        1  CO=AG EDUCATION COMMITTEE OF THE FRESNO COUNTY FA
E3      174 *CO=AG EDWARDS
E4        2  CO=AG EDWARDS & CO
E5        1  CO=AG EDWARDS & SON
E6       86  CO=AG EDWARDS & SONS
E7       45  CO=AG EDWARDS & SONS INC
E8        5  CO=AG EDWARDS AND SONS
E9     1335  CO=AG EDWARDS AND SONS INC
E10       1  CO=AG EDWARDS AND SONS INC.
E11       1  CO=AG EDWARDS ASSET MANAGEMENT
E12       1  CO=AG EDWARDS DOWNGRADES CLEAR CHANNEL COM
E13    2622  CO=AG EDWARDS INC
E14       1  CO=AG EDWARDS MEDIA
E15       1  CO=AG EDWARDS UPGRADES BMC SOFTWARE INC
E16       1  CO=AG ELECTRIC INC
. . . .  
?s e3:e13
      S3    3998  CO='AG EDWARDS':CO='AG EDWARDS INC'

6. EXPAND this time with no punctuation but use a space between the initials and SELECT E numbers.

?e co=a g edwards

Ref   Items  Index-term
E1        2  CO=A G EDWARD AND SONS INC
E2        1  CO=A G EDWARD SONS
E3     1902 *CO=A G EDWARDS
E4       57  CO=A G EDWARDS & CO
E5       16  CO=A G EDWARDS & SON
E6        1  CO=A G EDWARDS & SON MARK
E7     2191  CO=A G EDWARDS & SONS
E8        1  CO=A G EDWARDS & SONS (UK) LIMITED
E9        2  CO=A G EDWARDS & SONS AMARILLO
E10       1  CO=A G EDWARDS & SONS HAS LEASED
E11     311  CO=A G EDWARDS & SONS INC
E12       1  CO=A G EDWARDS & SONS INC.
E13       1  CO=A G EDWARDS & SONS INVESTMENTS
E14       1  CO=A G EDWARDS & SONS MILESTONES
E15       1  CO=A G EDWARDS & SONS TO HOST EVENT FOR POTENTIAL
E16       1  CO=A G EDWARDS & SONS TO MOVE INTO NEW OFFICE
E17       1  CO=A G EDWARDS & SONS WHEN JOHNSON
E18       1  CO=A G EDWARDS & SONS' LOCAL OFFICE OFFERING CARE
E19       1  CO=A G EDWARDS & SONSANALYST STEPHEN F EAST
E20       1  CO=A G EDWARDS AND SON
E21      82  CO=A G EDWARDS AND SONS
E22      40  CO=A G EDWARDS AND SONS INC
E23       7  CO=A G EDWARDS ASSET MANAGEMENT
E24       1  CO=A G EDWARDS BOULDER
E25       2  CO=A G EDWARDS CAPITAL
Enter P or PAGE for more 
?p
Ref   Items  Index-term
E26       1  CO=A G EDWARDS CAPITAL INC
E27       2  CO=A G EDWARDS CO
E28       1  CO=A G EDWARDS FINANCIAL SERVICES
E29       1  CO=A G EDWARDS FOCUS LIST
E30     772  CO=A G EDWARDS INC
E31      16  CO=A G EDWARDS INC (AGE)
E32       2  CO=A G EDWARDS INVESTMENTS
E33       1  CO=A G EDWARDS NAMED ONE OF TOP COMPANIES
E34       1  CO=A G EDWARDS ON LIST OF BEST COMPANIES
E35       1  CO=A G EDWARDS REIT
E36       1  CO=A G EDWARDS RETAILING CONFERENCE
E37       1  CO=A G EDWARDS SECURITY RESOURCES
E38       1  CO=A G EDWARDS TECHNOLOGY GROUP
E39       5  CO=A G EDWARDS TRUST CO
E40       2  CO=A G EDWARDS TWIN FALLS
E41       2  CO=A G EDWARDS UNIVERSITY
E42       1  CO=A G EDWARDS 2006 ENERGY CONFERENCE
E43       3  CO=A G ELDER ELEMENTARY SCHOOL
. . . .

?s e1:e40
      S4    5408  E1:E12, E20:E40

7. This time invert the name and follow it with a comma and the first initial.

SELECT E numbers.

?e co=edwards, a

Ref   Items  Index-term
E1        1  CO=EDWARDS/BILLETT PRODUCTIONS
E2        8  CO=EDWARDS/WASATCH ENTERPRISES
E3        0 *CO=EDWARDS, A
E4        2  CO=EDWARDS, A C (INSURANCE BROKER)
E5        1  CO=EDWARDS, A G, & CO
E6       58  CO=EDWARDS, A G, & SONS
E7       56  CO=EDWARDS, A G, & SONS INC
E8       85  CO=EDWARDS, A G, INC
E9        1  CO=EDWARDS, A. G., & CO.
E10       3  CO=EDWARDS, A. G., & SONS INC.
E11       1  CO=EDWARDS, A. G., INC.
E12       1  CO=EDWARDS, BLAKE, ENTERTAINMENT
E13      12  CO=EDWARDS, CHARLES B., & CO.
. . . .
?s e5:e11
      S5     207  CO='EDWARDS, A G, & CO':CO='EDWARDS, A. G., INC.'

8. Still invert the name, but follow it with a space and an open parenthesis and the first initial.

SELECT relevant E numbers.

?E CO=EDWARDS (A

Ref   Items  Index-term
E1        1  CO=EDWARDOS PIZZA
E2      646  CO=EDWARDS
E3        0 *CO=EDWARDS (A
E4        2  CO=EDWARDS (A.G.)
E5      117  CO=EDWARDS (A.G.) INC.
E6       84  CO=EDWARDS (A.G.), INC.
E7        1  CO=EDWARDS (A)
E8        6  CO=EDWARDS (A) BANK
E9      131  CO=EDWARDS (AG)
E10       1  CO=EDWARDS (AG) & CO
E11      26  CO=EDWARDS (AG) & SONS
E12      85  CO=EDWARDS (AG) & SONS INC
E13      24  CO=EDWARDS (AG) INC
E14       1  CO=EDWARDS (AG) LIFE INSURANCE
E15       1  CO=EDWARDS (ALICE) REALTY
. . . .

?S E4:E13
      S6     476  CO='EDWARDS (A.G.)':CO='EDWARDS (AG) INC'

9. DISPLAY SETS (DS) to view all the Sets created.

?ds

Set     Items   Description
S1       1949   E1:E17, E21, E22,E24, E25
S2          3   CO='A. G. *EDWARDS & SONS'
S3       3998   CO='AG EDWARDS':CO='AG EDWARDS INC'
S4       5408   E1:E12, E20:E40
S5        207   CO='EDWARDS, A C (INSURANCE BROKER)':CO='EDWARDS, A.
S6        476   CO='EDWARDS (A.G.)':CO='EDWARDS (AG) INC'

10. “OR” the sets together. The colon acts as OR, combining all the results into one set.

11. Narrow results by restricting retrieval to specific publication years.

?s s1:s6
      S7   11960  S1:S6

?s s7/2007:2008
           11960  S7
        14212162  PY=2007 : PY=2008
      S8    1257  S7/2007:2008


RELATED HOW DO I...? SOLUTIONS

 

 

NEED HELP?

Contact the Dialog Knowledge Center
Within North America +1 800 3 DIALOG (334 2564)
Outside North America 00 800 33 DIALOG (33 34 2564)
Web Form www.dialog.com/contacts/webform

Stock #: 54816; Last modified: 22 Oct 2011



You are viewing the
Dialog Classic Version

Click below to view the
DialogLink 5 Version
Dialog Home   |   About Dialog   |   Site Search
Copyright Notices   |   Terms of Use   |   Privacy Statement