MID Function form Excel

ZoeM

Hi Community.

I have a rather weirdly simple scenario, I have a field with three numbers and I want to split them up into three separate columns, like text to columns in Excel. 

The first and last numbers I used:

ToNumber(Left(ToString([Scale]), 1))

ToNumber(Right(ToString([Scale]), 1))

But the middle number I cannot extrapolate. I tired the Substring(String,start,length) formula but I got the infamous error:  Type Mismatch, number provided...

Any help rendered will be truly appreciated.

Thableaus

Hi @ZoeM 

Use RegEX tool in Parse mode with this expression (\d)(\d)(\d)

Much easier.

Cheers,