Looking to Search and Sort String Twice, though am having issues

[jonathanupr]

I am inputing from an access file a test library, the files in the access file are out of alphabetical order...thus I search and sort and bring these into LV in alphabetical order.  But I am running into the issue of trying to further search and sort the second column of info via the model number:

example:

Model ............. Model #

Zetor               55

Challenger        55

Ford                55

Zetor               66

Challenger        66

Ford                 66

Zetor               45

Challenger        45

Ford                45

Zetor               96

Challenger        96

Ford                 96

Need to Return the Files as per below:

Zetor               45

Challenger        45

Ford                45

Zetor               55

Challenger        55

Ford                55

Zetor               66

Challenger        66

Ford                 66

Zetor               96

Challenger        96

Ford                 96

[jcarmody]

This works.  (That green thing is a Sort Array__ogtk.vi)
 

  

Message Edited by jcarmody on 12-09-2009 11:52 AM

[Ben]

... and if you are not fond of green, an array of clusters will sort the array based on the first element in the cluster and the second will be used to break ties. So use the cluster order to determine on which filed it get sorted.

Ben

[jonathanupr]

actually in my original post I had a brain-lapse on what the final sort needed to be....

I was looking for this:

Challenger        45

Challenger        55

Challenger        66

Challenger        96

Ford                 45

Ford                 55

Ford                 66

Ford                 96

Zetor                45

Zetor                55

Zetor                66

Zetor                96

thanks for the quick response.

[jcarmody]

Now I'm sure I've gone off the deep end...

 

[jcarmody]

---

Ben wrote:

... and if you are not fond of green,[...]

Ben

---

What is this world coming to?

[tst]

Jim, are you aware that the CCT easily allows you to have the FP and BD in the same PNG? No need to make two.

[jcarmody]

---

tst wrote:
Jim, are you aware that the CCT easily allows you to have the FP and BD in the same PNG? No need to make two.

---

Thanks.  I saw that possibility but was worried about the snippet extractability of a BD/FP CCT PNG (:))
I tested it and it worked.  I should have tested it before...

PS - I'm not stepping on anybody's toes with the CCT plug in my signature, am I?

[Ben]

---

jcarmody wrote:

---

Ben wrote:

... and if you are not fond of green,[...]

Ben

---

What is this world coming to?

---

Did I just do a freudian to expose my real objection to global warming types i.e. I am against everything green?

Nope.

Ben

[tst]

---

jcarmody wrote:

PS - I'm not stepping on anybody's toes with the CCT plug in my signature, am I?

---

No. It's there for people to use, so any publicity is good, as long as it's not too much in-your-face.