Removing New Line Character in Input file

4830 Views

Hi Experts,

I Have a question about "New Line Character". I searched in SDN before posting this thread, But I didn't get answer.

Question:

Let me say my Client requirement first. After loading the data(Millions of Records) into SAP through LSMW, they asked write a program for validation of those loaded records based on I/P file. I wrote a program and It is success full.

But, the problem is when file is in Application server in 'BIN' format, a new line character(#) is created. While comparing the last record of each line, it doesn't match. How to remove this new line character(#) in I/P file for each line of record? Please see the below records for example

PROVINCIA DE BUENOS AIRE|   |1870|AR| #
PROVINCIA DE BUENOS AIRE|   |1876|AR| #
BOX 7407 PRINCETON|   |085437407|US|NJ#
5756 2 A   CAPITAL FEDERAL|   |1431|AR|00#

Note: This New line character is not matching the string "#".

Please help me guys, so many objects are related with this concept. I appreciate quick response. Please.

Thanks

Sai