Convert Alphanumeric to numeric SAP Business one hana

[nikunjmehta2290]

Hello all,

How to convert field Alphanumeric to numeric?

Convert field "U_G_ENTRY" this field into numeric.

Regards,

nikunj

[former_member681242]

Hi Nikun,

you should use REPLACE_REGEXPR

e.g.

SELECT REPLACE_REGEXPR('[A-Z]' IN '0001A' WITH '' OCCURRENCE ALL) "replace_regexpr" FROM DUMMY;

Kind regards

Tobias

[nikunjmehta2290]

How to convert UDF which have datatype TEXT into Alphanumeric in query report?

[LoHa]

Hi Nikun,

have a look to this site

regards Lothar

[nikunjmehta2290]

How to convert UDF which have datatype TEXT into Alphanumeric in query report?