I have a list of Item numbers that I need broken down to their root SKUs. Some have suffixes, some have prefixes, others do not. I need help determining how to trim only those with suffixes within the list. Example: Item NumberRoot SKU100260100260100267100267100268100268100270100270100270W100270100276100276100276P100276280591280591280591A280591PRM2840PRM2840TCK1524TCK1524WHU4016WHU4016WHU4059WHU4059WHU4072WHU4072WTI0956WTI0956WTI0957WTI0957XE4494XE4494XM0101XM0101XM0120XM0120

Trimming SKU suffixes

I have a list of Item numbers that I need broken down to their root SKUs. Some have suffixes, some have prefixes, others do not. I need help determining how to trim only those with suffixes within the list.

Example:

Item Number	Root SKU
100260	100260
100267	100267
100268	100268
100270	100270
100270W	100270
100276	100276
100276P	100276
280591	280591
280591A	280591
PRM2840	PRM2840
TCK1524	TCK1524
WHU4016	WHU4016
WHU4059	WHU4059
WHU4072	WHU4072
WTI0956	WTI0956
WTI0957	WTI0957
XE4494	XE4494
XM0101	XM0101
XM0120	XM0120

Accepted answers

AdamR_AYX

Here is another formula option without regex 🙂

TrimRight([Item Number],"ABCDEFGHIJKLMNOPQRSTUVWXYZ")

All comments

MarqueeCrew

If you want just the numbers you can try the text cleanse tool or use this formula:

regex_replace([sku],"\u", '')

cheers,

mark

Ladarthure

Hi @kaitturner,

to do what you aksed I would use a find replace tool, supposing you have a database of all "expected" SKU, find a workflow attached with an example with your data!

sample_sku.yxmd

AdamR_AYX

Here is another formula option without regex 🙂

TrimRight([Item Number],"ABCDEFGHIJKLMNOPQRSTUVWXYZ")

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703