Hi!
int() actually is not needed. When str() returns something like '123.00', set FIXED option OFF, or just use str(Num,12,0) to tell it to do not use the fractional part of the number.
>Thanks very much :)
>Just think it should be Num=int(val(m.cObjValue))
>
>Thanks again!
>jimi
>
>>Hi!
>>
>>Then modify your expression:
>>
>>Num=val(m.cObjValue)
>>iif(Num=0,'AAAA'+m.cObjValue,padl(Num,4,"0")+substr(m.cObjValue,len(alltrim(str(Num)))+1))
>>
>>Note I did a mistake in the previos expression...
>>
>>HTH.
>>
>>>more info, A1, B2A, 10C, 3, B2 should be sort to 3, 10C, A1, B2, B2A...
>>>
>>>
>>>>Hmm.. how if the list contains a set of strings, each string have length 1-4, which can be any combination of 1-9, A-Z?
>>>>
>>>>such as A1, B2A, 10C, 3... etc.
>>>>
>>>>is it still possible to use asort? I still cant think of a way to do it yet..
>>>>
>>>>any idea?
>>>>
>>>>Jimi
>>>>
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.