regarding with data valiodation in BDC

[Former Member]

I have problem in data validation in BDC

suppose there is a thousand record before uploading data i want to know a particular data validation.eg. a-z characters,A-Z characters.

[Former Member]

Hi,

Check this example:

data: i_len type i.

data:i_off type i.

data: i_sub type i.

data: i_up type i.

data: statement(200) type c.

i_len = strlen( statement ).

if i_len > 1.

i_off = 0.

do i_len times.

if statement+i_off(1) ca 'asdfghjklqwertyuiopzxcvbnm'.

add 1 to i_sub.

endif.

if statement+i_off(1) ca 'ASDFGHJKLQWERTYUIOPMNBVCXZ'.

add 1 to i_up.

endif.

add 1 to i_off.

enddo.

endif.

write:/ i_sub.

write:/ i_up.