topic Re: Remove symbol from flat fileduring data load in Application Development and Automation Discussions

Remove symbol from flat fileduring data load

Former Member — Mon, 04 May 2009 12:46:42 GMT

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.

Re: Remove symbol from flat fileduring data load

Former Member — Mon, 04 May 2009 13:08:46 GMT

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 ?

Re: Remove symbol from flat fileduring data load

Former Member — Mon, 04 May 2009 13:17:19 GMT

check if this helps you:

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

Regards,

Ravi Kanth Talagana

Re: Remove symbol from flat fileduring data load

Former Member — Mon, 04 May 2009 14:13:51 GMT

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

Thanks,

Re: Remove symbol from flat fileduring data load

Former Member — Mon, 04 May 2009 14:41:30 GMT

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

Re: Remove symbol from flat fileduring data load

Former Member — Tue, 05 May 2009 13:09:15 GMT

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.

Re: Remove symbol from flat fileduring data load

Former Member — Tue, 05 May 2009 13:17:10 GMT

hi,

use the statement

condense ls_string no-gaps.

Regards,

Siddarth