topic Re: Numeric value check in Application Development and Automation Discussions

Numeric value check

Former Member — Thu, 20 Feb 2014 18:28:54 GMT

Hi all,

I am using NUMERIC_CHECK to check if the value is numeric or not.

But if I input a value like 122.22 the system treats this value as Character.

I also tried another fm CATS_NUMERIC_INPUT_CHECK with the same value, in the fm it gives me the same value in return but if i apply this fm in my program then it gives runtime error saying 'Unable to interpret . as number'

How to solve this?

any example.???

Re: Numeric value check

Former Member — Thu, 20 Feb 2014 18:44:41 GMT

You can catch the runtime error to decide whether it is a number or not. Something like this.

DATA str TYPE string. 
DATA num TYPE p LENGTH 15 DECIMALS 2. 
DATA is_number TYPE boolean. 
str = '122.22'. 
 
TRY . 
    num = str. 
    is_number = 'X'. 
  CATCH cx_sy_conversion_no_number. 
    is_number = ' '. 
ENDTRY. 
WRITE😕 is_number. 
 

Re: Numeric value check

Former Member — Thu, 20 Feb 2014 19:02:09 GMT

Hello Yash,

NUMBER_CHECK & CATS_NUMERIC_INPUT_CHECK both FM are trying to check number which are '0123456789 '.

In your example '122.22' dot after 122 system is treating as character. It is returning as Character.

You can use either of below approach.

DESCRIBE FIELD FLD TYPE T.
DESCRIBE FIELD FLD DECIMALS N.
PARAMETERS: P_DEC(10).

IF P_DEC CN '.123567890 '.

MESSAGE E307 WITH 'ENTER CORRECT VALUE'.

ENDIF.

FIELD-SYMBOLS <OFFSET> TYPE ANY.

NB = STRLEN( W_FIELD ).

DO NB TIMES.

W_INDEX = SY-INDEX - 1.

ASSIGN W_INDEX TO <OFFSET>.

IF W_FIELD+<OFFSET>(1) CO '0123456789.'.

else.

exit.

ENDIF.

ENDDO.

Re: Numeric value check

Former Member — Thu, 20 Feb 2014 19:21:00 GMT

Hi Yash,

As I understood , you want to check numeric with decimal also

Try this,

DATA : input(200) TYPE c,invalid TYPE c, valid TYPE c.

* Only dot then also invalid

IF input CO '.'.

invalid = 'X'.

* Contain otherthen numbers + dot then invalid

ELSEIF input CN '0123456789.'.

invalid = 'X'.

ELSE.

valid = 'X'.

ENDIF.

Keep this code in perform or function module check numeric

Thanks & Regards,

Arun

Re: Numeric value check

Former Member — Thu, 20 Feb 2014 20:45:27 GMT

Hi,

I'd also use the CO operator: "if lv_string CO '123456789.'."

all the best,

Kieran

Re: Numeric value check

Former Member — Fri, 21 Feb 2014 05:27:25 GMT

I am using module pool.

loop at it_weight INTO wa_weight.

if wa_weight co '0123456789.'.

st_REF-Zgross_WEIGHT = wa_weight-in.

ENDIF.

ENDLOOP.

after the loop on it_weight I have checked the condition. though it is not going in the if condition.

this is my code. I am getting value in wa_weight from clipboard.

Re: Numeric value check

Former Member — Fri, 21 Feb 2014 08:35:16 GMT

Hi,

May be spaces are present in wa_weight. If yes condense the wa_weight.

Thanks & Regards,

Arun