topic Re: validate the record while uploading into table in Application Development and Automation Discussions

validate the record while uploading into table

Former Member — Thu, 15 Mar 2007 14:09:31 GMT

Hi,

I am uploading records into the table, and it so happened that an incorrect record full of text data was there in theinput file, it got uploaded along with the records,

hence I need to modify the code to check for such data -it is text data.

I have an 'empid' field (only numbers). I used that field to check for numeric data some thing like this...

if itab-empid+0(1) between '0' and '1'.

move-corresponding itab to DTABLE.

APPEND DTABLE.

else.

continue.

endif.

it is not working, throwing a short dump.

is there a better way to validate this? All I am doing is if empid field has any text data do not read into the internal table.

Thanks,

Re: validate the record while uploading into table

Former Member — Thu, 15 Mar 2007 14:16:06 GMT

You could try something like this:

if itab-empid+0(1) CA '0123456789'.

move-corresponding itab to DTABLE.

APPEND DTABLE.

else.

continue.

endif.

I hope this helps.

- April King

Re: validate the record while uploading into table

Former Member — Thu, 15 Mar 2007 14:27:51 GMT

Thanks,

Re: validate the record while uploading into table

Laxmana_Appana_ — Thu, 15 Mar 2007 14:29:41 GMT

Hi,

Check this, It will work.

if itab-empid CO '12345 67890'.
move-corresponding itab to DTABLE.
APPEND DTABLE.
else.
.............
endif.

Regards

L Appana