Skip to Content
0
Former Member
Jan 17, 2013 at 06:39 AM

Custom report: How to remove this Strange Symbol # from BSEG-SGTXT.

152 Views

Hi,

I'm having a strange problem with symbol #

I am downloading data from BSEG table into excel file (using tab delimiter) using custom report and there is a field SGTXT with value ' Half Advance# '

I am using below statement to remove # from SGTXT, but the symbol is not deleting.

REPLACE ALL OCCURRENCES OF '#' in gs_output-SGTXT with ' '.

Looks like it is not HASH symbol, because when I tried

FIND ALL occurrences OF '#' IN gs_output-SGTXT MATCH COUNT lv_num.

RESULT of lv_num is showing as 0

When I add HASH symbol to that field and tried.

Concatenate '#' gs_output-SGTXT into gs_output-SGTXT.

FIND ALL occurrences OF '#' IN gs_output-SGTXT MATCH COUNT lv_num.

RESULT of lv_num is showing as '1'.

Any idea what might be that symbol?

The problem is when I downloaded the data into excel, it is thinking that the symbol is END OF ROW. Hence it is moving remaining fields after SGTXT into next row.

Somehow I have to remove that symbol from my custom report. Is there any FM or Method which will remove this strange symbol???

Kindly suggest.

Thanks

Seema