Forum Discussion

WILLIH's avatar
WILLIH
Icon for Helper I rankHelper I
5 years ago

Id sequence

How do I get my id's to sort in order?             
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi WILLIH ,

 

You need to convert the values into number, on the query editor if you click 123/ABC button you can select number on format.

WILLIH's avatar
WILLIH
Icon for Helper I rankHelper I
5 years ago

Hi MFelix,

I did try changing the format of the data to a number but it still does not let me sort it. You can't see it from the pictures but some of the id's also have alpha in them like "D0017" or "EB255". Would that make a difference because the data is still being recognized as text?

 

Thanks,

 

WILLIH

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi WILLIH  if you alphanumeric codes you cannot convert to number,

     

    Believe the best option is to add a new column with some additional zeros to the left on alll the number so you can then sort the numbers. 

     

    Not on computer now but will send out the code tomorrow.