Sort field using specific chain

fgirardin — Sat, 16 Nov 2024 04:19:26 GMT

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:

Correct formatting:

Is there a way to sort using the specific naming explained above ?

Thank you for your help

Re: Sort field using specific chain

Gysbert_Wassenaar — Wed, 27 Feb 2019 19:01:54 GMT

See attached qvw

fgirardin — Thu, 28 Feb 2019 12:45:38 GMT

Thank you a lot ! It works great and I learned something new 🙂

Have a great day !!

Fabien