topic Re: Filter Numeric Variables in Application Development and Automation Discussions

Filter Numeric Variables

Former Member — Tue, 18 Dec 2007 05:36:57 GMT

Hi Experts,

I wanted the way how I can identify the particular variable is wheather character type or numeric type??

For example in my database i have records like abc, xyz, 125 etc.

Now I wanted to filter the data based on numeric & character file. Say in one table i want XYZ, ABC & in other one I want 125.

I believe that we have certain system fields available. Let me suggest.

Re: Filter Numeric Variables

Former Member — Tue, 18 Dec 2007 05:39:55 GMT

Hi Neha,

Try using the logic

itab-(fieldname) > 0. "Field value

if yes numeric.

else.

not numeric.

endif.

Thanks,

Kasiraman R

Re: Filter Numeric Variables

Former Member — Tue, 18 Dec 2007 05:45:13 GMT

Hi,

Neha

for tht u declare two internal tables

then in another internal table get database records then do like this

loop at maininternaltable.

if record co '0123456789'.

append to first_itab.

else.

append to second_itab.

endif.

if u do in this way u r problem get solves.

plzz reward if usefull

feel free to ask any quiries my mail id is mutyalasunilkumar@gmail.com

plzz dont forget to reward if useful.

Re: Filter Numeric Variables

Former Member — Tue, 18 Dec 2007 06:16:36 GMT

Neha still if u dont get the answer plz dont hesitate to ask

and if u r problem is solved plzz reward

Re: Filter Numeric Variables

jayanthi_jayaraman — Tue, 18 Dec 2007 06:21:48 GMT

Hi,

sy-abcde will tell you whether the value ia alphabet.For numbers, you need to declare a varaible of 10 character length with value '0123456789' as suggested. If there is no alphanumeric, then you can code

if v1 ca sy-abcde.

"move it to itab1.

elseif v1 ca '0123456789'.

"move it to itab2.

endif.

Re: Filter Numeric Variables

Former Member — Tue, 18 Dec 2007 06:22:30 GMT

Hi,

Use FM 'NUMERIC_CHECK' to find out whether the value is numeric or char.

Input: 123

Result : HTYPE : NUMC

INPUT: 35CA

Restul : CHAR

Hope this helps you.