Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Himanshu,
You could try this too- KeepChar(ColumnName, 0123456789)
Cheers!
Hi,
Try Num#(ColumnName) as ColumnName
Thanks & Regards
Akshat Agrawal
Hi Himanshu,
You could try this too- KeepChar(ColumnName, 0123456789)
Cheers!