sorting alpha-numeric data

[dbell]

Hello all my 1st post.

I'm not the brightest one out there so I need help. I want ot sort this data in columb C;

RES,0 Ohm,1/8W,5%,1206
RES,0 Ohm,1/8W,5%,1206
RES,1 Ohm,1/10W,5%,0805
RES,1 Ohm,1/8W,1%,1206,MF
RES,1.2K,1/10W,5%,0805
RES,1.2K,1/8W,5%,1206
RES,1.37K,1/8W,1%,1206
RES,1.3M,1/10W,1%,0805
RES,1.40K,1/8W,1%,1206,MF
RES,10 Ohm,1/8W,5%,1206
RES,10 Ohm,1W,5%,2512
RES,10.2K,.1/8W,1%,1206
RES,10.5K,1/8W,1%,1206
RES,10.7K,1/8W,1%,1206
RES,100 Ohm,1/10W,1%,0805
RES,330 Ohm,1/10W,1%,0805
RES,100K,1/8W,5%,1206
RES,100K,1W,5%,2512
RES,102K,1/10W,1%,0805
RES,105 Ohm,1/10W,1%,0805
RES,10K,1/10W,.1%,0805
RES,10M,1/10W,1%,0805

I just want to sort by the 1st numeric value in accending order with the output like this;

RES,0 Ohm,****
RES,10 Ohm,***
RES,105 Ohm,***
RES,1K,***
RES,2.5K,***
RES,1M,***

How wouls I get this? Hope this is enough information.

 

[plettieri]

Please elaborate a little more for me anyway


...when you say the first numberic value, the outcome is 0, 10, 105, 1, 2.5, and 1.

Are the K = thousasnds?
M=millions?



How to sort?

pll
This message was edited by plettieri on 2002-10-17 08:49

 

[dbell]

[No message]

 

[dbell]

The K values are thousands and the M values are millions. I would like to sort this data in a numeric order starting at 0 and ending at ###M. The info after the 1st numeric value is not as inportant as the 1st value.

Hope this is what your asking for. If not ask again.

Thanks, D