How to drive Prefix, base and suffix for the part number - Base should start with Number

[MaheshR]

		Manual Working Results
Details		Len	Prefix	Base	Suffix
WXXSBA		6	0	WXX	SBA
38xxxxS		7		3xxxxx	S
N805X44S		8		N805XXX	S
D2TZ119XX		9	D2TZ	11XX	X
F3DC733XXX		10	F3DC	7335X	XX
JX7A22053UA		11	JX7A	22053	UA
ML3B600C06EE		12	ML3B	600C06	EE
FT1T14K733ZDD		13	FT1T	14K733	ZDD
9L147202BD3JA6		14	9L14	7202	BD3JA6
DC343F832DC35B8		15	DC34	3F832	DC35B8
8A5313E709AA35B8		16	8A53	13E709	AA35B8
NL3B1564417GC31Y6		17	NL3B	1564417	GC31Y6
DA5354237W21AE3DN1		18	DA53	54237W21	AE3DN1
FL3B18519A58LAF3ZHE		19	FL3B	18519A58	LAF3ZHE
AMHC3J99501A42AA52CP		20	AMHC3J	99501	A42AA52CP

[alexnajm · Accepted solution]

@MaheshR I gave enough information to solve this problem. I will give the formulas, but not the workflow since someone with Core certification should be able to work with formulas. Please try it yourself. you can come back once you show us what you've tried yourself.

LEFT([Details],4)

SUBSTRING([Details], 4, 4)

RIGHT([Details],2)

If you care about the length, you can add these into an IF statement with IF Length([Details])>=10 THEN ... ELSE ... ENDIF

Good luck!

[MaheshR]

Can any one help on this

[MaheshR]

Below is the work flow which I have created but I am not able to get the correct results. 

[MaheshR]

Can you please check and support on the workflow and the formula.