cancel
Showing results for 
Search instead for 
Did you mean: 

How to check is-numeric through formula ?

bicchu1
Explorer
0 Kudos

Hi Experts,

Can you please let me know how to check is_numeric <field> in formula editor of HANA. The field I need to validate is a charachter type field and comes with different kind of values eg '00009876543' or "Mnagment_User'. I need to use some string formulas if the value is '00009876543'.

Thanks in advance for all your help.

Cheers

Prabir

Accepted Solutions (0)

Answers (1)

Answers (1)

bicchu1
Explorer
0 Kudos

My problem is resolved where I have used replace() function to repalce leading zeros with blank but it would good to know if we have something to check is-numeric

Cheers

Prabir