Remove symbol from flat fileduring data load

[Former Member]

I have a huge text file which has square symbol on it and getting data load error, message no. BRAIN 290 which is data conversion error for invalid characters during ODS (BW object) activation.

Just wondering how to clean this square invalid characters in transfer rule?

I can't fix in the source and don't want to fix in flat file but in Transfer Rule using code.

I need help in writing code. What command will it be to check the square symbol and remove? there is no fix position. In each record, symbol is in different position.

See the link to understand the data: http://www.erpmastering.com/Document1.pdf

Thanks.

[Former Member]

I dont know what is ODS or transfer rule. But if you can take each character and check whether that lies between either 0 to 9 and / or a(A) to z(Z). However does it not make sense to fix this in source. What if that is a part of the information ?

[former_member181962]

check if this helps you:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0afbb81-f219-2c10-4181-b20f6b10...

Regards,

Ravi Kanth Talagana

[Former Member]

If it is ABAP, how you would write code to remove square symbols?

Thanks,

[former_member181962]

I would have used the replace all occurances statement.

replace all occurences of '<Copy the square box character and paste here>' in ls_string with ''.

Regards,

Ravi Kanth Talagana

[Former Member]

What would be the code to remove null values?

If there are 2 square symbols one after the other, how to remove that?

In few fields, the square symbols are end of the field records.

Thanks.

[Former Member]

hi,

use the statement

condense ls_string no-gaps.

Regards,

Siddarth