Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Help me!!!unknown character....

Former Member

‎2007 Oct 24 9:21 AM

0 Likes
2,044

Guys!!help me on this...

Im downloading a file w/c has a short text field.

Some short text field has this kind of character w/c I dont know.

sample: "File□string".

Did you notice that square symbol?I dont know how would I delete that.

Furthermore , everytime I debug my program that square symbols turns into a "#" symbol..so what I did was I used the "replace all occurrences of "#" in field with space".

But nothing happens , the "#" symbol is not replace by space.

Hope you could help me on how to solve this.

and also when I copy and paste the text with square symbol in ms word the square symbol doesnt exist..I find it so weird....

Please do help me experts....

Guys!!help me on this...

Im downloading a file w/c has a short text field.

Some short text field has this kind of character w/c I dont know.

sample: "File□string".

Did you notice that square symbol?I dont know how would I delete that.

Furthermore , everytime I debug my program that square symbols turns into a "#" symbol..so what I did was I used the "replace all occurrences of "#" in field with space".

But nothing happens , the "#" symbol is not replace by space.

Hope you could help me on how to solve this.

and also when I copy and paste the text with square symbol in ms word the square symbol doesnt exist..I find it so weird....

Please do help me experts....

Reply
7 REPLIES 7
Read only

Former Member

‎2007 Oct 24 9:24 AM

0 Likes
1,322

check the hexadeicmal value of that character, when SAP can't display a special character it outputs # Yiou can click the plus icon in debugging to find out the hexadecimal value

regards, Rob.

Read only

Former Member
In response to Former Member

‎2007 Oct 24 9:31 AM

0 Likes
1,322

Hi Rob,

I check the hexadecimal of that "#" symbol and I found out that the equivalent hexadecimal of "#" is 000A. What should I do next?

Read only

Former Member

‎2007 Oct 24 9:33 AM

0 Likes
1,322

Hi Salma,

From where are you donloading the file ? Is the file downloaded from SAP ?

Regards,

sandipan.

Read only

Former Member
In response to Former Member

‎2007 Oct 24 9:37 AM

0 Likes
1,322

Yes , its from sap..in the table where that text is maintained it has this "□" symbol but when I debug the program the "□" symbols became "#".My problem is everytime the text has this kind of character the next text after that character proceeds to the next line of the excel.I did use gui_download...the only way for me to solve this problem is to delete that "□" symbol w/c I dont know how..any idea expert???

Thanks..

Read only

Former Member
In response to Former Member

‎2007 Oct 24 9:43 AM

0 Likes
1,322

btw , the file is downloaded from SAP to EXCEL..

Please help experts...

Read only

Former Member
In response to Former Member

‎2007 Oct 24 2:33 PM

0 Likes
1,322

Hi Salma,

I was just wondering how the "□" appeared in the database table. Is it a custom table or SAP table ?

Make sure the file name ends with .XLS also specify the delimited file and set write_field_separator = 'X' ,

Also, what language the text is written ?

Regards

Sandipan

Message was edited by:

Sandipan Choudhuri

Read only

Former Member

‎2007 Nov 19 8:13 AM

0 Likes
1,322

Hi,

data: c_htab value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

replace all occurrences of c_htab in ltext-tdline with space.

Try this out.

Suganya