Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to use a SP that our partners provided us in order to sort products nomenclatures
Here is the unsorted table
There is not a lot of data but each item's order is defined using suffixes like this example (not totally accurate):
Master Item = H0004291 prefix A = Item N° >> H000429110 << suffix A (first level item)
Secondary Items = H00042911010 prefix A = Item N° + 10 >> H00042911010 << suffix B (second level item)
Third items = H0004291101010 prefix A = Item N° + 10 >> H0004291101010 << suffix C (second level item)
Raw datas:
H000429110 | H000429 |
H0004291101010 | ETC-253 |
H0004291101020 | TP-054 |
H0004291101030 | ZJO6013 |
H0004291101040 | BP25 Ø06 x Ø10 x 10 |
H0004291101050 | AM-023A |
H0004291101055 | AM-026A |
H0004291101060 | BN 831 Ø6 |
H0004291101070 | ZJO5014 |
H0004291101080 | ZJO1012 |
H0004291101090 | ZJO1018 |
H00042911010502010 | Courbhane Ø15.7 |
H00042911010552010 | Courbhane Ø15.7 |
H00042911010202010 | TI-057 |
H00042911010102020 | CH-004A |
H00042911010202020 | PI-004A |
H00042911010102040 | TU-019A |
H00042911010102050 | FO-015A |
H000429110102020103010 | 1.4305 Ø 6-f7 Chrome-Dur |
H000429110101020403010 | 2.0371 Tu Ø15.02 Ø20 |
H000429110102020203010 | 2.0401 Ø15 |
H000429110101020503010 | 2.0401 Ø20 |
H000429110101020203010 | 2.0401 Ø25 |
Correct formatting:
Is there a way to sort using the specific naming explained above ?
Thank you for your help
See attached qvw
Thank you a lot ! It works great and I learned something new 🙂
Have a great day !!
Fabien