Formula to just take number from column

TMonty0319

I have a column with different assets

Tank 1

Engine 1

Engine 2

Tank 2

Tank 3

Engine 4

My question is I just want to take out the number from each and put in new column so can sort by just the number in each asset. Can someone help with this?

ColemenWilson

In Magic ETL you can use REGEX_REPLACE(). Here is the formula:

REGEXP_REPLACE(your_column, '[^0-9]', '')

Sean_Tully

If the number is always the last character of the asset value, I would create a beast mode: right(asset, 1).

TMonty0319

What if some assets have 2 words then the number?

ColemenWilson

In Magic ETL you can use REGEX_REPLACE(). Here is the formula:

REGEXP_REPLACE(your_column, '[^0-9]', '')

TMonty0319

Thanks that worked!