topic Re: make changes in text file. in Application Development and Automation Discussions

make changes in text file.

Former Member — Fri, 07 Aug 2009 08:54:23 GMT

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

Re: make changes in text file.

Former Member — Fri, 07 Aug 2009 09:48:28 GMT

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,

Re: make changes in text file.

Former Member — Fri, 07 Aug 2009 10:43:20 GMT

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 .

Re: make changes in text file.

Former Member — Fri, 07 Aug 2009 14:35:00 GMT

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

Re: make changes in text file.

Former Member — Fri, 07 Aug 2009 15:12:08 GMT

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

Re: make changes in text file.

Former Member — Mon, 10 Aug 2009 04:21:15 GMT

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

Re: make changes in text file.

Former Member — Fri, 14 Aug 2009 07:19:05 GMT

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

Re: make changes in text file.

Former Member — Mon, 17 Aug 2009 11:44:34 GMT

thanks a lot to all of you