text to num format of a column having length 20

[Himanshu]

Hi,

I have a text column which has below values:

0000B101498600000201

0000B106216400000101

How can I change this to num format?. I have used num function but it is disappearing the column values.

Thanks & Regards,

Himanshu

[akshatagrawal]

Hi,

Try Num#(ColumnName) as ColumnName

Thanks & Regards

Akshat Agrawal

[Sweta_Sharma · Accepted solution]

Hi Himanshu,

You could try this too- KeepChar(ColumnName, 0123456789)

Cheers!