Sort field using specific chain

[fgirardin]

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

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[fgirardin]

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

Have a great day !!

Fabien