AnsweredAssumed Answered

Help with a custom Sort for electronic parts

Question asked by Husky on Mar 7, 2009
Latest reply on Mar 8, 2009 by Husky

Title

Help with a custom Sort for electronic parts

Post

I need to build labels that get sorted since this is for electronic parts where 3 or 4 parts are in 1 bin

The problem is there are designators for multipliers

 

For instance on resistors 470 is written as 470r,  4700 is 4K7, 4,700,000 is 4M7

I need a sort that would sort these in this order 470r, 4K7, 4M7 

 

Other parts

.0001 is 100p, .001 is 1n, .01 is 10n, .1 is 100n, 1 is 1u 10 is 10u

I need these sorted as 100p, 1n, 10n, 100n, 1u, 10u

 

Anyone have any ideas without entering both since there are thousands of parts

Thanks 

 

 

Outcomes