forum.vdsworld.com

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

Hi, I am trying to sort a list of data:
example:
8,yadayadayda
9,yadayadayda
10,yadayadayda
11,yadayadayda

and when I apply the LIST SORT Command (vds4) the list becomes like this:

10,yadayadayda
11,yadayadayda
8,yadayadayda
9,yadayadayda

instead of being in numerical order. Is there an easier way to sort the numerical data without adding leading zeros to the numbers?

Mac · Posted: Sat Mar 13, 2004 10:32 am Post subject:

I don't think so. Any standard "sort" starts with the leftmost
character - which doesn't leave ya many options.

You can make a routine to automatically pad zeros when
your list is loaded though. Wink

Cheers, Mac Smile

Mac · Posted: Sat Mar 13, 2004 11:22 am Post subject:

Here's an example using a second unsorted list for editing.
It uses a var you can change to pad the numbers (currently
3 digits).

You shouldn't perform the change directly on a sorted list,
because you don't know if the edited item will be re-inserted
above or below the current index position (sorted lists cannot
use LIST PUT). Wink

_____________________________________________________________

Serge · Posted: Sat Mar 13, 2004 11:21 pm Post subject:

a suggestion...not sure if it is a good one...why don't you start your numbering from 10 onwards (as long as you don't go beyond 99)

serge

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

Thanks Mac your answers are always swift and to the point.

Serge, also a good suggestion which I would have used if I had control of the start data. Writing a companion program and it's just working with the data that another program outputs so I have to manipulate the data as is.

I was using a @FORMAT(@FDIV(%%var,10000000),8.8) command in a GOSUB routine to do the necessary padding. Was alot simplier then actually adding 0s onto it with a REPEAT command. I would then inturn use @FMUL(%%VAR,10000000) to restore the number. This worked well and good until some non-english versions of windows encountered problems. specifically german version. They defaulted to using a coma for a decimal place instead of a period and this threw the routine off when trying to convert back and remove the 0s. Not really sure as to why it did this. However, end all solution was as follows:

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

oi! this routine works only VDS environment app not in a compiled exe. *back to drawing board*

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

Scratch that found a work around. Kind of an oddity but here is:

Orignal Problematic Line

Mac · Posted: Tue Mar 16, 2004 4:12 am Post subject:

The PARSE command requires the recipient vars to be
inside quotes (separated by semi-colons if there are
more than one):

PARSE "%%var1", %%ItemToParse

or

PARSE "%%var1; %%var2", %%ItemToParse

I'm surprised it even works like ya have it... Wink

Cheers, Mac Smile

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

haha, I know.

I wanted to try it because it made the routine alot easier to write and I am glad it worked. good to know eh?

was the main reason why i posted to code, i hadn't seen any source written like that previously but it definately simplies the process of me having rewrite a list of multiple variables.

Mac · Posted: Tue Mar 16, 2004 9:56 am Post subject:

Very interesting... but I'm not exactly sure how it's easier. Wink

When you add the var names to LIST 7, it puts another
"layer" between you and the data.

Adding vars to the list normally (not the quoted names)
should achieve the same results - or am just I missing
something here? Confused

LOL, wouldn't be the first time.... Wink

Cheers, Mac Smile

moke · Contributor Joined: 02 Jan 2002 Posts: 162

Hey Mac,

FYI, I just used your method of padding leading zeros for a similar purpose & it works nice, thanks Smile

.

I kinda thought I could just use something like this:

repeat
%1 = @succ(%1)
info @format(%1,3.0)
until @equal(%1,10)

but i guess you know the result. Sad

moke

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

not using the "quoted" variables on the list in my code would not work the same, because it would return the values of the variables instead the names of the variables. the reason for the quotes is to preverve the variable names for reassigning during the routine. otherwise it would try to write a value to a value and error

ie:

List add,7,%%var1|%%var1

would be replaced with value1|value1

with the quotes

list add,7,"%%var1;"|%%var1

the first portion of the string would return %%var1 as a name and not a value and the second is a value.

not sure if i explained the right.

Mac · Posted: Wed Mar 17, 2004 12:58 am Post subject:

moke - glad ya could use it. Wink

TSgigs - Clear as mud... Laughing

I'll just take your word for it. Wink

Cheers, Mac Smile

TSgigs · Newbie Joined: 28 Nov 2000 Posts: 9 Location: Michigan USA

In the end your right again Mac,

The routine does not work. It only works in the vds app itself and not in a compiled exe. the " " work around i put in allowed the routine to run but would not write the variables, so I have to scratch the routine and will likely adopt your method. Was trying to avoid rewriting as little code as possible. Will have to anyway lol

Thanks for you help guys.