Super Advanced Search Algorithm Annoyance

[IREALLYambatman]

Sooo.. I have a ton of data and I need it arranged all by one Row... And using Regex, and custom order, and ascending.. I'm 90% of the way there, unfortunately I'm now kinda stuck, I need to sort like this :

[TABLE="width: 500"]
<tbody>[TR]
[TD]AAA[/TD]
[TD]AAA x2[/TD]
[TD] AAA x5[/TD]
[TD]AAA x10[/TD]
[/TR]
</tbody>[/TABLE]

And Excel does this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]AAA[/TD]
[TD]AAA x10[/TD]
[TD]AAA x2[/TD]
[TD]AAA x5[/TD]
[/TR]
</tbody>[/TABLE]

So Excel Looks at each charecter and says that x10 should come before X2 because you well, it fails to understand that 10 < 2.

What can I do to fix this? I have all the rest done, all the AAA's and BBB's are in order, it's just the x2 or x5 or x20 or xwhatever that it fails to realize that is a number.. help?

 

[Yongle]

Classing sorting "numbers as text" issue
- easily solved if you make numbers consistent
- insert leading zeros
- with your example increase all numbers to 2 digits
- if largest number is 3 digits then make EVERY number 3 digits


So instead of
[TABLE="class: cms_table"]
<tbody>[TR]
[TD]AAA [/TD]
[TD] AAA x2
[/TD]
[TD] AAA x5
[/TD]
[TD] AAA x10
[/TD]
[/TR]
</tbody>[/TABLE]

Amend data like this and the problem goes away
[TABLE="class: cms_table"]
<tbody>[TR]
[TD]AAA[/TD]
[TD] AAA x02
[/TD]
[TD] AAA x05
[/TD]
[TD] AAA x10
[/TD]
[/TR]
</tbody>[/TABLE]

 

[IREALLYambatman]

Classing sorting "numbers as text" issue
- easily solved if you make numbers consistent
- insert leading zeros
- with your example increase all numbers to 2 digits
- if largest number is 3 digits then make EVERY number 3 digits


So instead of
[TABLE="class: cms_table"]
<tbody>[TR]
[TD]AAA[/TD]
[TD] AAA x2[/TD]
[TD] AAA x5[/TD]
[TD] AAA x10[/TD]
[/TR]
</tbody>[/TABLE]

Amend data like this and the problem goes away
[TABLE="class: cms_table"]
<tbody>[TR]
[TD]AAA[/TD]
[TD] AAA x02 [/TD]
[TD] AAA x05[/TD]
[TD] AAA x10[/TD]
[/TR]
</tbody>[/TABLE]

thanks dude, you rock!