Is there a way to force Rev to see a mixed alpha numeric string as numeric if it begins with numbers?

Context: series of cards auto loaded with images where the field "photofileName" comes in and the image ref for image 1 on the card is the same.

e.g.
card no         fld "photoFileName"

card 1   1.BigBlueBird
card 2   10.RedOrange
card 3   11.WhiteApple
card 4   2.SmallBlackBird

Ideal the person naming the photos uses zero padding, but typically I find users oblivious to this issue and I simply need to give them a way to resort from a button to:

card 1   1.BigBlueBird
card 2   2.SmallBlackBird
card 3   10.RedOrange
card 4   11.WhiteApple

Sort cards of this stack numeric by fld "photoFileName"

does nothing... no error, no resort... I assume because the mixed strings cannot be evaluated as numbers...
What would be a work around...?? I could use some complicated parsing routine but it would fail if another user decided to use a different delimiter (in this case he's used a dot), so I need a global solution that says to Rev -forget the alpha characters at the end of the string, just use the numbers at the beginning. iViewMedia does this automatically in its catalog system... i.e. it assumes if there are numbers at the beginning to sort by numbers and "10*alphaChars" follows "9*alphaChars", not "1*alphaChars" in any listing....


TIA

Sannyasin Sivakatirswami
Himalayan Academy Publications
at Kauai's Hindu Monastery
[EMAIL PROTECTED]

www.HimalayanAcademy.com,
www.HinduismToday.com
www.Gurudeva.org
www.Hindu.org

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to