Support : DialogLink : Online Help : MAP : Field Prefix Option

MAP (continued)

Field Prefix Option

Use the ff= option to change the prefix associated with the field that was MAPped. The prefix indicated in ff= is assigned to the terms contained in the SearchSave created by MAP. This option allows these terms to be SELECTed from a different field than the one from which they were MAPped, either in the same database or in another suitable database.

To delete a prefix: You can delete a prefix from the search terms saved with MAP by entering the equals sign (=) without a preceding field code (e.g., MAP XX <TEMP> / =). The SearchSave will then EXECUTE in the Basic Index.

Note: MAP SY, which runs in most chemical directories, automatically deletes the prefix when the MAP command is processing. The resulting saved search can then be EXECUTEd in the Basic Index of any file containing chemical information.

In the following example, MAP RC is used in CHEMSEARCH™ (File 398) to create a SearchSave of Component CAS^® Registry Numbers. This command (similar to MAP RN for cross-file searching of CAS^® Registry Numbers) is useful in searching for polymers and their component monomers. For example, if a search of CHEMSEARCH retrieves a record representing a polymer, you can save the Component CAS^® Registry Numbers in it by using the MAP RC command and specifying the RN= prefix.

The SearchSave created in the example contains the CAS^® Registry Numbers of the monomers constituting the polymer; the monomers are identified by executing the search in the same file.

• To use the Field Prefix option:

File 398:Chemsearch 1957-2007/Mar
       (c) 2007 Amer.Chem.Soc.

      Set  Items  Description
      ---  -----  -----------

?select rn=82370-34-1
      S1       1  RN=82370-34-1
?t s1/5
1/5/1 
DIALOG(R)File 398: Chemsearch
(c) 2007 Amer.Chem.Soc. All rights reserved.

CAS Registry Number: 82370-34-1 ( POLYMER ) 
Molecular Formula: 
(C10H20O5Si.C8H14O2.C8H8.C7H12O2.C6H10O3.C5H8O2)x 
Ring System Data: 
(01) (nr=01; sr=6; ar= fr=C6.01; ir=46-150-18) 
CA Name: 
HP= 2-Propenoic acid (9CI) 
   SB= 2-methyl- 
   NM= butyl ester, polymer with butyl 2-propenoate, 
   ethenylbenzene, 2-hydroxyethyl 2-methyl-2-propenoate, 
   methyl 2-methyl-2-propenoate and 3-(trimethoxysilyl)propyl 
   2-methyl-2-propenoate 
. . . .
Component CAS Registry Numbers: 
(80-62-6 97-88-1 100-42-5 141-32-2 868-77-9 2530-85-0) 

Component RN Component Molecular Formula 
===========================================================
1) 80-62-6  C5H8O2 
2) 97-88-1  C8H14O2 
3) 100-42-5  C8H8 
4) 141-32-2  C7H12O2 
5) 868-77-9  C6H10O3 
6) 2530-85-0  C10H20O5Si 

Subfile: CHEMNAME  6 LITERATURE REFERENCE(S) IN FILE 399. 
Last Update: 200309 

?map rc temp steps /rn=
Temp SearchSave "TD502" stored
7 Select Statements, 6 Search Term(s) 
SearchSave TD502

1 SearchSave(s),  6 Search Term(s)

?exs
Executing TD502
      S2       4  RN=80-62-6
      S3       3  RN=97-88-1
      S4       2  RN=100-42-5
      S5       3  RN=141-32-2
      S6      17  RN=868-77-9
      S7      13  RN=2530-85-0
      S8      42  S2:S7

(MAP: Term Qualifier Option) 

top