Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to sort one dimension in a table that contains both numeric values and text values.
I have the following numbers and text value:
HBM24203 |
HBM24438 |
1131 |
1112 |
HBM24518 |
HBM24507 |
HBM24451 |
1170 |
1162 |
1161 |
1153 |
1151 |
1122 |
1117 |
1115 |
HBM24120 |
HBM24119 |
HBM24109 |
HBM24098 |
HBM24050 |
HBM24248 |
HBM24219 |
HBM24214 |
1142 |
1141 |
1135 |
1132 |
1114 |
1125 |
1123 |
HBM24142 |
1143 |
HBM24047 |
1148 |
1144 |
HBM24297 |
HBM23994 |
HBM24331 |
I would like to sort like this:(first sort by numbers and then by text):
1112 |
1114 |
1115 |
1117 |
1122 |
1123 |
1125 |
1131 |
1132 |
1135 |
1141 |
1142 |
1143 |
1144 |
1148 |
1151 |
1153 |
1161 |
1162 |
1170 |
HBM23994 |
HBM24047 |
HBM24050 |
HBM24098 |
HBM24109 |
HBM24119 |
HBM24120 |
HBM24142 |
HBM24203 |
HBM24214 |
HBM24219 |
HBM24248 |
HBM24297 |
HBM24331 |
HBM24438 |
HBM24451 |
HBM24507 |
HBM24518 |
Hi