topic Re: Removing the carriage return / Tab during data extraction in Application Development and Automation Discussions

Removing the carriage return / Tab during data extraction

Former Member — Thu, 04 Nov 2004 20:22:54 GMT

Hi ,

I have an issue with removing the carriage return / Tab from the extracted (Flat File) data from SAP EKPO table.

1) While uploading(Long Back) the Legacy data to SAP tables the carriage returns and Tabs in Product description were uploaded to SAP tables.

2) Now I am extracting data from bkpf,..EKPO.. tables to a flat file .

3) When I extract the data i. PO number, Product description,......

The Product description is going to 3 to 5 lines depending on the carriage returns and Tabs in the Product description. Ekpo-txz01

Ex : Mfg # DS104NA / NET######GEAR DS104 Hub######model

I want this product description in one continuous line. It is possible only by removing the Carriage returns and tabs from product description before concatenating and TRANSFERING the file to Server.

4) What is getting: The line is breaking @gear @ Hub due to Carriage return/Tab

Mfg D NET

GEAR DS104 Hub

model .

5) What is required is: in one line

Mfg D NETGEAR DS104 model

In the process I am extracting product description from Ekpo-txz01 . So it is internal table. Now I want to remove the carriage return / Tab .

How these can be removed.

Thanks,

Vasu

Re: Removing the carriage return / Tab during data extraction

nablan_umar — Thu, 04 Nov 2004 21:05:49 GMT

Vasu,

You can replace tab and carriage return of your text using REPLACE command.

REPLACE cl_abap_char_utilities=>horizontal_tab in

Ekpo-txz01 with ' '.

REPLACE cl_abap_char_utilities=>CR_LF in

Ekpo-txz01 with ' '.

Re: Removing the carriage return / Tab during data extraction

Former Member — Thu, 04 Nov 2004 23:01:47 GMT

Hi Umar,

First thanks for giving some solution.

When I use the code as suggested,

1. It is removing 'Tab' only. It is not removing carriage return.

2. It is removing one TAB at a time.

3. Still I am seeing a BOX [] after the text in flat file. i.e carriage return is not removed from Ekpo-txz01 .

I Used this and passing Ekpo-txz01 in a loop.

REPLACE cl_abap_char_utilities=>horizontal_tab in

Ekpo-txz01 with ' '.

REPLACE cl_abap_char_utilities=>CR_LF in

Ekpo-txz01 with ' '.

Can you suggest some solution/idea for this.

Thanks,

Vasu

Message was edited by: vasu bandi

Re: Removing the carriage return / Tab during data extraction

former_member641343 — Fri, 05 Nov 2004 09:58:13 GMT

Try using the TRANSLATE statement instead (as this replaces all instances of the constant found in the string being evaluated).

Hope this helps.

Rosie Brent

Message was edited by: Rosie Brent

Re: Removing the carriage return / Tab during data extraction

nablan_umar — Fri, 05 Nov 2004 15:48:06 GMT

Double-click on cl_abap_char_utilities=>CR_LF. You will see other attributes that equal to that BOX. Maybe it is NEWLINE.

Re: Removing the carriage return / Tab during data extraction

Former Member — Fri, 05 Nov 2004 18:57:58 GMT

Hi,

I have used all:

REPLACE cl_abap_char_utilities=>horizontal_tab in