topic Re: text to num format of a column having length 20 in App Development

text to num format of a column having length 20

Himanshu — Wed, 29 Sep 2021 15:07:11 GMT

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 — Thu, 30 Sep 2021 05:32:08 GMT

Hi,

Try Num#(ColumnName) as ColumnName

Thanks & Regards

Akshat Agrawal

Sweta_Sharma — Tue, 12 Oct 2021 08:26:11 GMT

Hi Himanshu,

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

Cheers!