Dialog
Dialog Support   >   "How Do I...?" Series   >   Engineering & Technology
Dialog "How Do I...?" - Engineering & Technology

Use the Product Code Finder to Locate Product Codes?

TOPIC: Because of variations in names of products, it is often easier and more comprehensive to search using a product code. The Dialog Product Code Finder™ (File 413) is designed to locate product codes (i.e. SIC, NAICS, etc.) in Dialog databases. Using File 413, you can quickly identify files that contain product formation and the appropriate codes to use for searching and view them in a preformatted table.

For this example we want to find the product code for interferometers and search a few databases for information on the product.

 

COMMAND SUMMARY

BEGIN 413
SELECT INTERFEROMET???
REPORT S1/PRODUCT
Follow the menu
REMOVE DUPLICATES
SELECT TEST??? AND MEASUREMENT? AND S5
TYPE S6/8,K/1 FROM EACH


HOW TO...



1. BEGIN File 413, Dialog Product Code Finder.

2. SELECT the equipment for which you want to find the code.

Note the three question marks (e.g., interferomet???) to indicate the keyword, plus three additional letters.


?b 413 

File 413:DIALOG PRODUCT CODE FINDER(TM) 2007/Mar
       (c) 2007 Dialog

      Set  Items  Description
      ---  -----  -----------
?s interferomet???
      S1      14  INTERFEROMET???


3. Use the REPORT command to retrieve a preformatted report containing the product name, code, file number and number of records.

 

4. Select a few items to move into databases and see some records.


?report s1/product

           DIALOG(R)File 413 :DIALOG PRODUCT CODE FINDER(TM)
                    (c) 2007 Dialog All rts. reserv.    

                      14 Products Available

                                           Product   File    Record
    Product Name                           Code      Number   Count
-------------------------------------------------------------------
  1 INTERFEROMETERS                        3832534   16         119
  2 INTERFEROMETERS                        3832534   18          65
  3 INTERFEROMETERS                        3832534   80          19
  4 INTERFEROMETERS                        38279907  516          9
  5 INTERFEROMETERS                        38279907  515          9
  6 INTERFEROMETERS                        3832534   570          1
  7 INTERFEROMETERS AND INTERFEROSCOPES    3843108   590         52
  8 INTERFEROMETERS AND INTERFEROSCOPES    3843108   593         15
  9 INTERFEROMETERS AND INTERFEROSCOPES    3843108   592          9
 10 INTERFEROMETERS AND INTERFEROSCOPES    3843108   594          1
 11 INTERFEROMETERS AND INTERFEROSCOPES    3843108   585          1
 12 OPTICAL LENSES FOR INTERFEROMETERS     3837130   590         10
 13 OPTICAL LENSES FOR INTERFEROMETERS     3837130   592          6
 14 OPTICAL LENSES FOR INTERFEROMETERS     3837130   593          2 

Enter item number(s), P for next page, or EXIT to end Report:
?1-3

Selected item(s): 1-3
Items from file(s): 16,18,80


5. Enter YES to save the items numbers selected to a SearchSave. You will automatically search the files you chose.


Enter YES to save items and begin searching these files,
P for next page, or EXIT to end Report:
?y

Temp SearchSave "TD625" stored
4 Select Statements, 3 Search Term(s)
SearchSave TD625

1 SearchSave(s),  3 Search Term(s)
Leaving Report/PRODUCT...

SYSTEM:OS  - DIALOG OneSearch
  File  16:Gale Group PROMT(R) 1990-2008/May 21
         (c) 2008 The Gale Group
  File  18:Gale Group F&S Index(R) 1988-2008/May 21
         (c) 2008 The Gale Group
  File  80:TGG Aerospace/Def.Mkts(R) 1982-2008/May 21
         (c) 2008 The Gale Group

      Set  Items  Description
      ---  -----  -----------
      S1     119  PC="3832534 " FROM 016
      S2      70  PC="3832534 " FROM 018
      S3      23  PC="3832534 " FROM 080
      S4     212  S1:S3


6. REMOVE DUPLICATES (RD) to keep unique records only.

7. Narrow the search further using keywords.

Again, truncation (???) is used in place of three additional letters.


?rd
      S5     148  RD  (unique items)

?s test??? and measurement? and s5
         1325801  TEST???
          178749  MEASUREMENT?
             148   S4
      S6      32  TEST??? AND MEASUREMENT? AND S5


8. TYPE a few records FROM EACH database using Formats 8 to see descriptors and K to see a window of 30 words around the keywords.

 

Note: Some records have been omitted from this display.


?t s6/8,k/1 from each

6/8,K/1 (Item 1 from file: 16)
DIALOG(R)File 16: Gale Group PROMT(R)
(c) 2008 The Gale Group. All rights reserved.

14745696    Supplier Number: 175630520 (USE FORMAT 7 FOR FULLTEXT)

MT9820A tunable external cavity laser.(Tools of the Trade)(Brief article)
Feb , 2008
Word Count: 125
Publisher Name: Advantage Business Media
Descriptors: *Interferometers--Product information
Event Names: *330 (Product information )
Geographic Names: *1USA (United States )
Product Names: *3832534 (Interferometers)
Industry Names: ENG (Engineering and manufacturing industries);
SCIE (Science and technology )
SIC Codes: 3827 (Optical instruments and lenses )
NAICS Codes: 333314 (Optical Instrument and Lens Manufacturing )
Trade Names: MT9820A (Optoelectronic device)_Product information
   Supplier Number: (USE FORMAT 7 FOR FULLTEXT)

Text:
 ...an unique combination of high-speed electronic and optical interferometry.Up to four real-time  measurements  are now possible with(+ or -)1 pm wavelength accuracy. This allows the use of MT9820A...

...Its compact format as well as its low price makes it best 
suitable for labs'  testing  benches. With its configuration,
MT9820A allows users to sweep continuously over several lasers
(up to four) in order to achieve a fast full-range  measurement .
Product Names:    
 *3832534   (Interferometers)
Industry Names:  . . . .   

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 #: 54713; Last modified: 14 Sep 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