Programa para encontrar

Que tal.

Me gustaria que me ayudarnan a generar un macro que me ayude a determinar la
clase de componente dependiendo de su descripción, por ejemplo, tengo una
lista de numeros de parte con su descripción, existe otro campo vacio (que es
el que quiero llenar); el usuario, cada vez que seleccione la celda vacia,
valla a la columna anterior, tome la descripción para separarla por espacios,
comas u otros caracteres (pejemplo: ~!@#$%^&*()_+-=<>?”{}|\][,./) y en la
celda vacia abra un formulario un cuadro de lista de las clases mas parecidas
para que el usuario pueda seleccionar una. Si no encuentra nada parecido,
lógicamente que el formulario no tendra datos para poder seleccionar.

El campo de Clase se podria llenar por ejemplo:
En el caso que tengamos:

3850012000-384 *DIODE, SCHOTTKY MBR0520

Pueda separar la descripción por los datos:

DIODE
SCHOTTKY
MBR0520

En el cuadro de lista que despliegue el formulario daria la respuesta:
6DA - Diodes Default
6DB - Diodes Switching
6DC - Diodes Zener
6DD - Diodes Schottky
6DE - Diodes Rectifiers
6DF - Diodes Thyristors

De esa lista el usuario pueda seleccionar un resultado que seria: 6DD -
Diodes Schottky


Algo complicado, pero se los agradecere mi correo es kizaki49@hotmail.com si
necesitan que les envie la tabla, solo diganme…

MUCHAS GRACIAS
Manny90



Lista de numeros de parte
Item number Description Class
9010215111G-384 *PWA, ANALOG VIDEO INPUT
5220590000-384 CAP 470UF 25V 20%
6122461000-384 CONN, XLR RA 5C
6260005001-384 JACK/JACK, BNC, 75 OHM, RT ANGLE
8010215111-384 SCH, ANALOG VIDEO INPUT
8172350417-384 SPEC, LABELS FOR SERIAL NUMBERED ASSY AND COMPONENT SCANNING
9010215112G-384 *PWA, ANALOG VIDEO INPUT, SMT
0000000010-384 B/M NOTE:
2111-0001-384 DIODE,SMT,DUAL
272-032-000-384 IC AD8055AR OPA SM ANDE
272-111-000-384 IC AD8132AR OPA SM ANDE
272-114-000-384 IC AD9235BRU-40 ADC 12BIT SM ANDE
3810001000-384 XSTR, NPN, MMBT2222A
3810007000-384 XSTR, PNP, MMBT2907A
3821549000-384 IC, 79M05 (DPAK)
3830277000-384 IC, LM4040CIM3-2.5
3830424000-384 IC, SN65LVDS9637D ESD
3830444000-384 *IC, MIC2940 (TO-263)
5450308617-384 RES 4.75M OHM 1% 1/8W 0805
5450331105-384 RES 15 OHM 1% 1/10W 0603
5450331109-384 RES 22.1 OHM 1% 1/10W 0603
5450331111-384 RES 26.7 OHM 1% 1/10W 0603
5450331112-384 RES 30.1 OHM 1% 1/10W 0603
3830458000-384 IC, LM393 (SOIC-08 )
3830591000-384 IC, 78M05 (DPAK)
3830667000-384 IC, LOGIC GATE INVERTER
3830687000-384 IC, AD835A
3830823000-384 IC, 74LVC1G125
3831021000-384 IC, AD7888 ESD
3831226000-384 IC, TL082C OP AMP ESD
3831228000-384 IC, 74LCX574 (TSSOP-20)
3831229000-384 IC, OP282 DUAL OP AMP ESD
3831231000-384 IC, 74HC4053 ESD
3831232000-384 IC 74HC4051 ESD
3831233000-384 IC, 74HC4538 ESD
3831236000-384 IC, 74ACT00 ESD
3831351000-384 IC, LM358 DUAL OP AMP 3-32VSUP
3850012000-384 *DIODE, SCHOTTKY MBR0520
3850039000-384 DIODE, SCHOTTKY, HSMS-2802
3850066000-384 *DIODE, SCHOTTKY, MMDL770
3930072000-384 *CPLD, XC9572XL (QFP-64)
4940487000-384 <*>IND, PWR 100UH 10% 5MM SMT
4960320302-384 IND, CHIP 1200NH 2% 0603
4960320304-384 IND, CHIP 1800NH 2% 0603
4960320307-384 IND, CHIP 3300NH 2% 0603
5150179023-384 CAP 8.2PF 0603 C0G 50V -/+0.5PF
5150179101-384 CAP 10PF 0603 C0G 50V 5%
5150179103-384 CAP 12PF 0603 C0G 50V 5%
5150179105-384 CAP 15PF 0603 C0G 50V 5%
5150179109-384 CAP 22PF 0603 C0G 50V 5%
5150179111-384 CAP 27PF 0603 C0G 50V 5%
5150179115-384 CAP 39PF 0603 C0G 50V 5%
5150179117-384 CAP 47PF 0603 C0G 50V 5%
5150179121-384 CAP 68PF 0603 C0G 50V 5%
5150179123-384 CAP 82PF 0603 C0G 50V 5%
5150179201-384 CAP 100PF 0603 C0G 50V 5%
5150179205-384 CAP 150PF 0603 C0G 50V 5%
5150179301-384 CAP 1000PF 0603 C0G 25V 5%




Commodity
REF - REFERENCE ITEM
005 - SOLDER
030 - OFFICE SUPPLIES
031 - PAPER
032 - WRITING UTENSILS
033 - FORMS/PRINTED MATERIAL
035 - NETWORK SERVICES
037 - SOFTWARE/UPGRADES
038 - HARDWARE LESS THAN $1000
040 - TRAVEL(AIR,CAR,LDG,RENT)
050 - LABOR(EQUIP P/N-CAL P/N)
060 - SAFETY
061 - SECURITY
070 - MAINTENANCE CONTRACTS
071 - BLDG MAINT CONTRACTS
072 - EQUIP MAINT CONTRACTS
075 - FIXED ASSETS
076 - MACHINERY & EQUIPMENT
077 - FURNITURE & FIXTURES
078 - AUTOMOBILES
090 - MISC EXPENSES
100 - ARTWK,LABOR,SOFTWARE,TOOL
878 - MISC-PRINTED/COPIED GOODS
879 - MISC - TAPE
880 - LABELS - STANDARD
950 - PACKAGING
C00 - CEC-GENERAL
C02 - CEC-EXTRUSION ALUMINUM
C04 - CEC-EXTRUSION AL. BASE ASM
C06 - CEC-CABLE ASM DISCRT. WIRE
C08 - CEC-CABLE ASM RIBBON
C10 - CEC-CABLE ASM OVERMOLD
C12 - CEC-CABLE ASM FIBER OPTIC
C14 - CEC-CABLE ASM COAX
C16 - CEC-CABLE ASM MISC.
C18 - CEC-DIE CAST ALUM
C20 - CEC-DIE CAST ZINC
C22 - CEC-DIE CAST MAGNESIUM
C24 - CEC-DIE CAST BASED ASM
C25 - CEC - Pressure Formed Plastic
C26 - CEC-DIE CUT COMPONENT
C27 - CEC - Rim Molded Plastic
C28 - CEC-INJECT MOLD PLASTIC
C30 - CEC-INJECT MOLD BASED ASM
C31 - CEC - Thermoset Plastic
C32 - CEC-THERMOFORMED PLASTIC
C33 - CEC-EXTRUDED PLASTIC
C34 - CEC-FABRICATED PLASTIC
C35 - CEC-SPRING/WIRE FORM
C36 - CEC-MACHINED METAL
C37 - CEC - Machined Metal based Ass
C38 - CEC-SHEETMETAL STAMPING
C40 - CEC-SHEETMETAL FABRICATN
C42 - CEC-SHEETMETAL BASED ASM
C43 - CEC-MOLDED RUBBER
C44 - CEC-SILICONE KEYPADS
C45 - CEC-MAGNETICS - CUSTOM
C46 - CEC-MEMBRANE SWITCHES
C48 - CEC-GRAPHIC OVERLAYS
C50 - CEC-MECHANICAL ASM MISC.
C51 - CEC-OTHER (MISC.)
C53 - CEC-PRINTED MATERIAL
C55 - CEC - Packaging Other/Misc.
C56 - CEC - Packaging Corrugate Pape
C57 - CEC - Packaging Die Cut Foam
C58 - CEC - Packaging Molded
C59 - CEC - Packaging Wood
C60 - CEC - Pump Assembly
C61 - CEC - Stepper Motor
C62 - CEC - Metal Sand Casting
C63 - CEC - Metal Investment Casting
C64 - CEC - Metal Permanent Mold Cas
C65 - CEC - Structural Foam Plastic
C66 - CEC - Metal Injection Molding
C67 - CEC - Machined Swiss Screw
C68 - CEC - Extruded Rubber
C69 - CEC - Beryllium Copper Stamped
C70 - CEC - Beryllium Copper Chemica
C71 - CEC - Casters
C81 - CEC-LABELS - CUSTOM
L00 - PCB GENERAL
L01 - PCB 1 Layer Single Sided
L02 - PCB 2 LAYER
L04 - PCB 4 LAYER
L06 - PCB 6 LAYER
L08 - PCB 8 LAYER
L10 - PCB 10 LAYER
L12 - PCB 12 LAYER
L14 - PCB 14 LAYER
L16 - PCB 16 LAYER
L18 - PCB 18 LAYER
L20 - PCB 20 LAYER
L22 - PCB 22 LAYER
L24 - PCB 24 LAYER
L26 - PCB 26 LAYER
L28 - PCB 28 LAYER
L30 - PCB 30 Layer
L32 - PCB 32 Layer
L34 - PCB 34 Layer
L36 - PCB 36 Layer
L38 - PCB 38 Layer
L40 - PCB 40 Layer and Over
L50 - PCB FLEX
L51 - PCB Flex Rigid
L52 - PCB BP ASM
L54 - PCB SPECIALITY
L56 - PCB OTHER (MISC.)
L57 - PCB RF 2 Layer
L58 - PCB RF 4 Layer and Over
L60 - PCB Hybrid
1AA - Memory Default
1BA - DRAM EDO/FPM Default
1BB - DRAM EDO Memory Modules
1BC - DRAM EDO less than 16Mb
1BD - DRAM EDO 16Mb and Greater
1BE - DRAM FPM Memory Modules
1BF - DRAM FPM less than 16Mb
1BG - DRAM FPM 16Mb and Greater
1CA - DRAM DDR/DDR-II Default
1CB - DRAM DDR Memory Modules
1CC - DRAM DDR-II Memory Modules
1CD - DRAM DDR less than 256Mb
1CE - DRAM DDR 256Mb and Greater
1CF - DRAM DDR-II 256Mb and Greater
1DA - DRAM SDRAM Default
1DB - DRAM SDRAM Memory Modules
1DC - DRAM SDRAM less than 128Mb
1DD - DRAM SDRAM 128Mb
1DE - DRAM SDRAM 256Mb
1DF - DRAM SDRAM 512Mb
1DG - DRAM SDRAM 1Gb and Greater
1EA - DRAM Rambus Default
1EB - DRAM Rambus Memory Modules
1EC - DRAM Rambus less than 144Mb
1ED - DRAM Rambus 144Mb
1EE - DRAM Rambus 288Mb
1EF - DRAM Rambus 288Mb and Greater
1GA - SRAM Synch Default
1GB - SRAM Synch Memory Modules
1GC - SRAM Synch less than 4M
1GD - SRAM Synch 4M
1GE - SRAM Synch 8M
1GF - SRAM Synch 9M
1GG - SRAM Synch 16M
1GH - SRAM Synch 18M
1GI - SRAM Synch 32M
1GJ - SRAM Synch Greater than 32M
1GK - SRAM Synch NTRAM >=4M
1GL - SRAM Synch DUAL PORT
1HA - SRAM Asynch Default
1HB - SRAM Asynch Memory Modules
1HC - SRAM Asynch Fast (<55ns) <4M
1HD - SRAM Asynch Fast (<55ns) 4M
1HE - SRAM Asynch Fast (<55ns) 8M
1HF - SRAM Asynch Fast (<55ns) 16M
1HG - SRAM Asynch Fast (<55ns) >16M
1HH - SRAM Asynch Slow (55ns +) <4M
1HI - SRAM Asynch Slow (55ns +) 4M
1HJ - SRAM Asynch Slow (55ns +) 8M
1HK - SRAM Asynch Slow (55ns +) 16M
1HL - SRAM Asynch Slow (55ns +) >16M
1HM - SRAM Asynch UTRAM
1HN - SRAM Asynch DUAL PORT
1IA - SRAM Other Default
1IB - SRAM DDR Memory Modules
1IC - SRAM DDR 8M and Greater
1ID - SRAM QDR Memory Modules
1IE - SRAM QDR 9M and Greater
1IF - SRAM ZBTRAM 2M and Greater
1IG - SRAM QDRII
1KA - SRAM CAM's Default
1KB - SRAM CAM's 2M
1KC - SRAM CAM's 4M
1KD - SRAM CAM's 9M
1KE - SRAM CAM's 18M or Greater
1LA - FIFO Default
1LB - FIFO Sync x8
1LC - FIFO Sync x9
1LD - FIFO Sync x18
1LE - FIFO Sync x36
1LF - FIFO Sync x72
1LG - FIFO Sync x80 and Greater
1LH - FIFO Async x4 - x9
1LI - FIFO Async x18 and Greater
1LJ - FIFO DDR x10
1LK - FIFO DDR x20
1LL - FIFO DDR x40 and Greater
1LM - FIFO Sync. Bi-Direct x18
1LN - FIFO Sync. Bi-Directl x36 & Gr
1MA - Flash Default
1MB - Flash Cards
1MC - Flash less than 4M
1MD - Flash 4M
1ME - Flash 8M
1MF - Flash 16M
1MG - Flash 32M
1MH - Flash 64M
1MI - Flash 128M and Greater
1MJ - NVRAM
1NA - EPROM/ROM/PROM Default
1NB - EPROM
1NC - ROM
1ND - PROM
1OA - EEPROM Default
1OB - EEPROM Serial - Micro (93C)
1OC - EEPROM Serial - I2C (24C)
1OD - EEPROM Serial - SPI (25C)
1OE - EEPROM Parallel
1OF - EEPROM Serial Other
1PA - DRAM OTHER default
1PB - DRAM VIDEO RAM
1PC - DRAM GRAPHICS RAM
2AA - Default
2BA - Amplifiers Default
2BB - Amplifiers OP
2BC - Amplifiers General Purpose
2BD - Amplifiers High Speed
2BE - Amplifiers Audio Pwr
2BF - Amplifiers Precision
2BG - Amplifiers Multipliers
2BH - Amplifiers Instrument
2BI - Amplifiers Differential
2CA - Converters Default
2CB - Converters A/D
2CC - Converters D/A
2CD - Converters Audio
2CE - Converters Digital +/-
2CF - Converters Mixed Sig
2CG - Direct Digital Synth.
2CH - Digital Pots
2DA - Interface Default
2DB - Interface Transm
2DC - Interface Recievers
2DD - Interface Line Drivers
2DE - Interface Actuators
2DF - Interface CONectivity
2DG - Interface Bus Term.
2DH - Interface Uarts
2DI - Interface PC
2DJ - Interface Periph. Drivers
2EA - Clock/Timers Default
2EB - Clock Buffers/Drivers
2EC - Clock Synthesizer/Driver
2ED - PLL Clock Drivers
2EE - Clock Timer
2EF - Clock/Timers Dig PLL
2EG - Clock/Timers PLL
2EH - Real Clock Timer
2EI - Clock Generators
2EJ - Clock/Timers Trans
2FA - Power Mgt Default
2FB - Power Mgt Ckts
2FC - Power Mgt Module
2FD - Power Mgt Linear/Volt Reg
2FE - Power Mgt Switch Reg
2FF - Power Mgt Volt Ref.
2FG - Power Mgt Superv. Circuit
2FH - Power Distribution Dev.
2FI - Voltage Monitors/Detect
2GA - Switch/Mux/Comprtr
2GB - Switches General
2GC - Switches High Speed
2GD - Switches Crosspoint
2GE - Mux/Demux
2GF - Comparators
2GG - Sensors
3AA - MPU/MCU/Peripherals Default
3BA - Processors Default
3BB - MPU 32bit
3BC - MPU 64bit
3CA - MicroControllers Default
3CB - MCU 8bit
3CC - MCU 16bit
3CD - MCU 32bit
3CE - MCU 64bit
3CF - MCU 128bit
3CG - MCU 256bit
3CH - MCU 512bit
3CI - MCU 512bit and Greater
3DA - DSP Default
3DB - DSP Fixed Point
3DC - DSP Floating Point
3EA - Peripherals Default
3EB - Drvrs/Accelrts (Graphic)
3EC - Bridges (PCI to xxx)
3ED - Controller
3FA - Computer Default
3FB - Computer Hard Drive
3FC - Computer Remove Disk
3FD - Computer Video Card
3FE - Computer Modems
3FF - Computer Single Board
3FG - Computer Monitors
3FH - Computer TFT LCD <= 10"
3FI - Computer TFT LCD > 10"
3FJ - s Computer STN LCD <= 10"
3FK - s Computer STN LCD >10"
3FL - s Computer EL LCD <= 10"
3FM - s Computer EL LCD > 10"
3FN - s Computer Plasma Display
3FO - s Computer Touch Screen
4AA - Gate Arrays/Prog. Logic Defaul
4BA - ASIC
4CA - PLD/FPGA Default
4CB - Pals/Gals
4CC - CPLDs
4CD - SPLDs
4CE - EPLDs
4CF - XPLDs
4CG - FPGAs
4CH - PDGAs
5AA - Optical/Comm Default
5BA - Wireless Default
5BB - Wireless Modulator/Demodulator
5BC - WirelessTransmitter/Receiver
5BD - WiirelessTransponders
5BE - Wireless IR
5BF - Wireless RF
5CA - Opticals Default
5CB - Optical Transceiver
5CC - Optical Receiver
5CD - Optical Transmitter
5CE - Optical Laser Driver
5DA - Adv Transmission Default
5DB - Adv Transmission Modulator
5DC - Adv Transmission Transceivers
5DD - Adv Transmission Transmitter
5DE - Adv Transmission xDSL
5EA - Telecom Default
5EB - Telecom Receivers
5FA - Adv Network Default
5FB - Switch Fabric Network Proc
5FC - Framers, Mappers, PHY's
5FD - Serdes (Serial/Deserial)
5FE - Mac Controller
6AA - Logic/Optos/Discretes Default
6BA - Logic Default
6BB - Logic TTL
6BC - Logic S
6BD - Logic LS
6BE - Logic C
6BF - Logic CD4000
6BG - Logic AS
6BH - Logic ALS
6BI - Logic F
6BJ - Logic HC/HCT
6BK - Logic AC/ACT/ACTQ
6BL - Logic FCT
6CA - Advanced Logic Default
6CB - Advanced Logic ABT/ABTE
6CC - Advanced Logic AHC/AHCT
6CD - Advanced Logic ALVT
6CE - Advanced Logic ALVC
6CF - Advanced Logic AUC
6CG - Advanced Logic AVC/AVCH
6CH - Advanced Logic BCT
6CI - Advanced Logic CBT/CBTLV
6CJ - Advanced Logic FB
6CK - Advanced Logic GTL/GTLP
6CL - Advanced Logic HSTL/SSTL/SSTV
6CM - Advanced Logic LCX
6CN - Advanced Logic LV/LVT/LVTH
6CO - Advanced Logic LVQ
6CP - Advanced Logic LVX
6CQ - Advanced Logic Tiny Logic
6CR - Advanced Logic VCX
6CS - Advanced Logic VHC/VHCT
6DA - Diodes Default
6DB - Diodes Switching
6DC - Diodes Zener
6DD - Diodes Schottky
6DE - Diodes Rectifiers
6DF - Diodes Thyristors
6EA - Transistors Default
6EB - Transistors Small Signal
6EC - Transistors MOSFET
6ED - Transistors IGBT
6FA - LED's/Optos Default
6FB - LED's
6FC - LED Arrays
6FD - Optocouplers
7AA - Cap Ceramic SMT Default
7AB - Cap Ceramic SMT0201
7AC - Cap Ceramic SMT0204
7AD - Cap Ceramic SMT0306
7AE - Cap Ceramic SMT0402
7AF - Cap Ceramic SMT0508
7AG - Cap Ceramic SMT0603
7AH - Cap Ceramic SMT0612
7AI - Cap Ceramic SMT0805
7AJ - Cap Ceramic SMT1206
7AK - Cap Ceramic SMT1210
7AL - Cap Ceramic SMT > 1210
7BA - Cap Intergrated s Default
7CA - Cap Ceramic TH Default
7CB - Cap Ceramic TH Radial
7CC - Cap Ceramic TH Axial
7CD - Cap Ceramic TH Disc
7DA - Cap Tant SM Default
7DB - Cap Tant SM2012 (P)
7DC - Cap Tant SM3216,3216L (A,S)
7DD - Cap Tant SM3528,3528L (B,T)
7DE - Cap Tant SM6032, 6032L (C,U)
7DF - Cap Tant SM7343,7343L,7343H
7EA - Cap Tant TH Default
7EB - Cap Tant TH Radial
7EC - Cap Tant TH Axial
7FA - Cap Alum Elect Deault
7FB - Cap Alum Elect Surf Mt
7FC - Cap Alum Elect Leaded
7GA - Cap Polymer Default
7HA - Cap Metal Poly Default
7IA - Cap Mica Default
7JA - Caps Microwave Default
7KA - Res-Thin Film Default
7KB - Res-Thin Film 0201
7KC - Res-Thin Film 0204
7KD - Res-Thin Film 0402
7KE - Res-Thin Film 0603
7KF - Res-Thin Film 0805
7KG - Res-Thin Film 1206
7KH - Res-Thin Film 1210 or Larger
7LA - Res-Thick Film Default
7LB - Res-Thick Film 0201
7LC - Res-Thick Film 0204
7LD - Res-Thick Film 0402
7LE - Res-Thick Film 0603
7LF - Res-Thick Film 0805
7LG - Res-Thick Film 1206
7LH - Res-Thick Film 1210
7LI - Res-Thick Film > 1210
7MA - Res Wire Wound Default
7MB - Res Wire Wound Surface Mount
7MC - Res Wire Wound Axial
7NA - Res Carbon Film Default
7OA - Res Metal Film Default
7PA - Res Metal Oxide Default
7QA - Res Carbon Comps Default
7RA - Resistor Networks Default
7SA - Resistor Arrays Default
7TA - Res-Potentiometer Default
7TB - Res-Potentiometer Surf. Mt
7TC - Res-PotentiometerThrough Hole
7UA - Trimmers Default
7UB - Trimmers Surface Mount
7UC - TrimmersThrough Hole
7VA - Res-Thermistor Default
8AA - CON CON Default
8BA - CON Wire and Cable Default
8CA - CON Power CONectors Default
8DA - CON Terminals Default
8EA - CON Fiber Optics Default
8EB - CON Fiber Optics ST
8EC - CON Fiber Optics FC
8ED - CON Fiber Optics SC
8EE - CON Fiber Optics LC
8EF - CON Fiber Optics MU
8EG - CON Fiber Optics MTP
8EH - CON Fiber Optics MPX
8FA - CON RF Default
8FB - CON RF Std
8FC - CON RF Min
8FD - CON RF Sub-Min
8FE - CON RF Mic-Min
8GA - CON Sockets Default
8GB - CON Sockets Memory - SIMM
8GC - CON Sockets Memory - DIMM
8GD - CON Sockets Memory - RIMM
8GE - CON Sockets PGA
8GF - CON Sockets BGA
8GG - CON Sockets SIP
8GH - CON Sockets DIP
8GI - CON Sockets PLCC
8HA - CON I/O Default
8HB - CON I/O D-Sub
8HC - CON I/O Universal Serical Bus
8HD - CON I/O Jack
8HE - CON I/O Plugs
8HF - CON I/O Header
8IA - CON BP Default
8IB - CON BP 2mm Hard Metric
8IC - CON BP Compact PCI / MZP
8ID - CON BP Fut bus (+) / MFB
8IE - CON BP DIN / Eurocard
9AA - E/M POWER SUPPLIES Default
9BA - E/M AC/DC POWER MODS Default
9CA - E/M DC/DC POWER MODS Default
9DA - E/M Thermal Mgmt Default
9DB - E/M Thermal Mgmt Heatsink
9DC - E/M Thermal Mgmt Fans
9EA - E/M Insulators Default
9FA - E/M Switches Default
9FB - E/M Switches Toggle
9FC - E/M Switches Rocker
9FD - E/M Switches Pushbutton
9FE - E/M Switches Slide
9FF - E/M Switches Tactile
9FG - E/M Switches Rotary
9FH - E/M Switches Keylock
9FI - E/M Switches Snap
9FJ - E/M Switches Dip
9FK - E/M Switches Thumbwheel
9FL - E/M Switches Encoders
9FM - E/M Switches Keypads
9FN - E/M Switches Membrane
9GA - E/M Relays Default
9GB - E/M Relays General Purpose
9GC - E/M Relays Low Signal (<3A)
9GD - E/M Relays Power (>3A)
9GE - E/M Relays Solid State
9GF - E/M Relays Contactors
9HA - Ckt Protect.-Fuses Default
9HB - Ckt Protect.-Fuses Reset PTC
9HC - Ckt Protect-Fuses-SMT
9HD - Ckt Protect-Fuses Axial/Cartr
9HE - Ckt Protect-Fuse Holders
9HF - Ckt Protect-Fuse Clips
9HG - Ckt Protect-Ckt Brkr
9IA - E/M Ferr Beads Default
9IB - E/M Ferr Beads Axial-PTH
9IC - E/M Ferr Beads SMT
9JA - E/M Filters Default
9JB - E/M Filters LC
9JC - E/M Filters EMI
9JD - E/M Filters RF
9JE - E/M Filters Band Pass
9JF - E/M Filters SAW
9KA - E/M Transformers Default
9KB - E/M Transformers Power
9KC - E/M Transformers Telcom
9KD - E/M Transformers LAN
9KE - E/M Transformers Common Mode C
9LA - Sig Proc-RF/Micro Default
9LB - Sig Proc-RF/Micro Amp
9LC - Sig Proc-RF/Micro Antenna
9LD - Sig Proc-RF/Micro Attenuat
9LE - Sig Proc-RF/Micro Coupler
9LF - Sig Proc-RF/Micro Detector
9LG - Sig Proc-RF/Micro Filter
9LH - Sig Proc-RF/Micro Freq Mult
9LI - Sig Proc-RF/Micro solator
9LJ - Sig Proc-RF/Micro Mixer
9LK - Sig Proc-RF/Micro Oscillator
9LL - Sig Proc-RF/Micro Phase Shiftr
9MA - E/M Inductors Default
9MB - E/M Inductors Chip SMT
9MC - E/M Inductors Other SMT
9MD - E/M Inductors Power
9ME - E/M Inductors Tunable-Variable
9NA - E/M Freq Control Default
9NB - E/M Freq Control Crystals
9NC - E/M Freq Control Crystal Osc
9ND - E/M Freq Control VCXO
9NE - E/M Freq Control TCXO
9NF - E/M Freq Control OCXO
9NG - E/M Freq Control TCVCXO
9NH - E/M Freq Control VCO
9NI - E/M Freq Control Program Osc
9OA - E/M Resonators Default
9OB - E/M Resonators Ceramic PTH
9OC - E/M Resonators Ceramic SMT
9OD - E/M Resonators SAW PTH
9OE - E/M Resonators SAW SMT
9PA - E/M Sensors Default
9QA - E/M Transducers Default
9RA - E/M Alarms / Buzzers Default
9SA - E/M Hardware Default
9TA - E/M MISC Default
9TB - E/M BATTERIES Default
9TC - E/M ANTENNAS Default
000 - N/A