topic Re: TEXT field / numeric field in Application Development and Automation Discussions

TEXT field / numeric field

Former Member — Sat, 04 Nov 2006 08:59:06 GMT

Hi abappers,

I need to check whether the content of a text field is numeric type or of character type? please any body can tell me how to do this?

Regards

Naren

Re: TEXT field / numeric field

anversha_s — Sat, 04 Nov 2006 09:02:52 GMT

hi,

CATS_NUMERIC_INPUT_CHECK

You can use the Function Module:

numeric_check.

Usage:

CALL FUNCTION 'NUMERIC_CHECK'

EXPORTING

STRING_IN = X

IMPORTING

STRING_OUT = X

HTYPE = H_TYPE.

if h_type = 'CHAR'.

WRITE:/ 'NOt Numeric'.

else.

write:/ 'Numeric'.

ENDIF

********without FM*********

If field CO '1234567890'.

Then its number.

else.

then character.

Endif.

rgds

anver

if hlped pls mark points

<i>hi narendran did it work</i>

Re: TEXT field / numeric field

Former Member — Sat, 04 Nov 2006 12:08:57 GMT

hi,

You can even use <b>CATS_NUMERIC_INPUT_CHECK</b>

* Check for Numeric Value

call function 'CATS_NUMERIC_INPUT_CHECK'
 exporting
   input = t_return-fieldval
 exceptions
   no_numeric = 1
   others = 2.

if sy-subrc = 0.
read table t_f4_table index t_return-fieldval.
endif.