AnsweredAssumed Answered

vrf Sorting

Question asked by VRFuser on Dec 3, 2007

Like • Show 0 Likes0
Comment • 3

Thanks all for input on sorting solutions. I’m still having some problems with a final implementation but as soon as I have something I will post back.

Thanks and regards

Nick

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

No one else has this question

Outcomes

3 Replies

VRFuser Nov 29, 2007 11:33 PM
Mark Correct
Correct Answer
Hi all

Does anyone have any ideas or implementation for correctly sorting an array of alphanumeric values. I am talking about sorting values of type (always a text string):

10.0.0.1.a

10.0.0.1.b

10.1.1

1.1.3.2

1.11.1.1

1.11.a.1

2.2.2.2

2.2.20.2.1.1.a

2.20.1

Essentially there is (currently) no limit on the length of the string.

Currently, if I simply use the vee sort function the output array is returned as:

1.1.3.2

1.11.1.1

1.11.a.1

10.0.0.1.a

10.0.0.1.b

10.1.1

2.2.2.2

2.2.20.2.1.1.a

2.20.1

Whereas correct sort order (in my opinion) should be:

1.1.3.2

1.11.1.1

1.11.a.1

2.2.2.2

2.2.20.2.1.1.a

2.20.1

10.0.0.1.a

10.0.0.1.b

10.1.1

I have tried various things like padding all entries to a particular size (string length).

Any ideas would be greatly appreciated.

Thanks

Nick

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Nov 30, 2007 3:44 AM
Mark Correct
Correct Answer
Stan Bischof (Richard S) <rsb@soco.agilent.com> wrote:
> "Robert Hemp" <rhemp@rim.com> wrote:
> > Hi All,
> >
> >
>
> >
> > The other way would interface / wrap around the VISA COM in some way
> > and filters directly whats send to the VISA interface.
> >
> >
> >
> > Can one these solutions work and has anybody tried this before?
> >
>
> I did something similar to that a ways back with SICL, so I'd expect
> that something similar could be done with VISA.
>
> Ended up creating library that duplicated the SICL commands and looked
> externally like SICL. It internally did SICL calls to the "real" SICL
> library.
>
> I would think that you could write a VISA lookalike and have it call
> the "real" VISA.
>
> Woudln't it maybe be easier to get the vendor to fix their code?

ONE THING TO WATCH OUT FOR---

This approach will fail miserably unless the vendor's software talks through your VISA library. There's plenty of ways to talk GPIB without VISA so unless you are sure that the target code talks through a VISA library that you can hijack, this won't work.

regards

Stan

--------------------------------------------------------------------------
Stan Bischof Agilent Technologies 707-577-3994 stan_bischof@agilent.com
--------------------------------------------------------------------------

---
You are currently subscribed to vrf as: ming_meng@agilent.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Nov 30, 2007 6:37 AM
Mark Correct
Correct Answer
"Nick Evans <nick@evanstest.co.uk> wrote:
> Hi all
>
>
>
> Does anyone have any ideas or implementation for correctly sorting an
> array of alphanumeric values. I am talking about sorting values of
> type (always a text string):
>
>
>
> 10.0.0.1.a
> 10.0.0.1.b
> 10.1.1
> 1.1.3.2
> 1.11.1.1
> 1.11.a.1
> 2.2.2.2
> 2.2.20.2.1.1.a
> 2.20.1
>
> Currently, if I simply use the vee sort function the output array is
> returned as:
>
>
> 1.1.3.2
> 1.11.1.1
> 1.11.a.1
> 10.0.0.1.a
> 10.0.0.1.b
> 10.1.1
> 2.2.2.2
> 2.2.20.2.1.1.a
> 2.20.1

Ah yes- the standard numeric vs string sort issue. This shows up in most all environments and VEE behaves the same as most.

That is strings are sorted character by character ( dictionary order )

Numbers are sorted by value.

You have strings, hence character so get character-by-character sort.
To get numeric sort you would need to convert to numbers.

SUGGESTION: change your naming format slightly so that you do NOT suppress leading zeroes and instead write into fixed-field width

10.00.00.01.0a
10.00.00.01.0b
10.01.01
01.01.03.02
01.11.01.01
01.11.0a.01
02.02.02.02
02.02.02.02.01.01.0a
02.20.01

If that's not practical, and assuming that the "a" and "b" imply that these are always hex values, then you could write a filter that converts these to hex strings as above, sorts them, then writes them back out in the original leading-zero-suppressed format.

regards
Stan

--------------------------------------------------------------------------
Stan Bischof Agilent Technologies 707-577-3994 stan_bischof@agilent.com
--------------------------------------------------------------------------

---
You are currently subscribed to vrf as: ming_meng@agilent.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Like • Show 0 Likes0
Actions

vrf Sorting

Outcomes

Related Content

Recommended Content