make changes in text file.

[Former Member]

Hi all,

we are uplaoding a text file by bdc but when we are importing our text file from some other system we are getting some box type symbol in that text file , how to delete those boxes before uploading it to sap

plz help

regards

sarabjit

[Former Member]

HI,

where exactly you are getting the box type,

is that a text file which you are uploading?

loop the internal table after uploading , search for the box and delete..

regards,

[Former Member]

Hi sarbajit,

you mentioned that when you importing the file boxes are appering in the file do you think so that boxes may be of the actually data insted of deleating the boxes check y it is happeing.if get assured that the data is correct after importing ,

use the replace button in the menu optin and replace the symble with space it will solove your problem .

[Former Member]

open your text file and press the SAVE AS option , here you can change ENDCODING is UTF-8 format.

[Former Member]

Hi,

That is aspecial character you need to remove this special character before you pass this data to BDC....

data: lv_char  type x value '0D'.
 do.
   if view_fields-value cs lv_char.
     replace lv_char with space into view_fields-value.
     condense view_fields-value.
     modify view_fields index lv_index transporting value.
   else.
     exit.
   endif.
 enddo.

here you might have to replace 0D with the correct value whihc you can see in dbug mode by clicking on the hex display button also try with '09 in place of 0D.

Regards,

Himanshu

[Former Member]

thanks himanshu,

but can u plz suggest me how to check hex value of that symbol , i don't have any idea abt it.

thanks

regards sarabjit

[Former Member]

Hi,

When in debug mode you can check the hex value of that field using the magnifying glass symbol on the right hand side of the value.

Regards,

Himanshu

[Former Member]

thanks a lot to all of you