brightyoyo
New Member
Hi, I am looking for a macro that can convert information form this format:
[pre]
[/pre]
Whereas, I need the individual reference designator with its own part number.
I have attached two files. One has a sample data and the other is a sample results.
https://www.dropbox.com/sh/rhffk9zwqy0b6yw/TP-BfxVSic
Thank You
[pre]
Code:
C110,C126,C128,C129 CAPN/U-0805
C119,C124,C125 G40X152K050
C12,C106 GRM188R71E474KA
C120 C0805C471K2RAC
C121 GRM21AR72A334KA
C18,C23 GRM31CR71E475KA
C25,C26,C27,C63,C68,C69,C80,C81,C86 GRM32DR71E106KA
These are reference designators with thier corresponding part number.
To:
C110 CAPN/U-0805
C126 CAPN/U-0805
C128 CAPN/U-0805
C129 CAPN/U-0805
C119 G40X152K050
C124 G40X152K050
C125 G40X152K050
C106 GRM188R71E474KA
C12 GRM188R71E474KA
C120 C0805C471K2RAC
C121 GRM21AR72A334KA
C18 GRM31CR71E475KA
C23 GRM31CR71E475KA
C25 GRM32DR71E106KA
C26 GRM32DR71E106KA
C27 GRM32DR71E106KA
C63 GRM32DR71E106KA
C68 GRM32DR71E106KA
C69 GRM32DR71E106KA
C80 GRM32DR71E106KA
C81 GRM32DR71E106KA
C86 GRM32DR71E106KA
Whereas, I need the individual reference designator with its own part number.
I have attached two files. One has a sample data and the other is a sample results.
https://www.dropbox.com/sh/rhffk9zwqy0b6yw/TP-BfxVSic
Thank You