topic Re: Replace error in Application Development and Automation Discussions

Replace error

Former Member — Thu, 22 Sep 2011 11:39:19 GMT

hi,

i want to replace the following code:

loop at itab into v_data1.

replace '<?xml version="1.0" encoding="utf-8" ?>' with ' ' into

v_data1-data .

replace '- <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02">'

with ' ' into v_data1-data.

endloop.

but here the code is not getting replace...kindly suggest where to change the code...

and i am getting su-subrc = 4...

The v_data1 will contain around 1000 characters..i need to search whole v_data1

Re: Replace error

Former Member — Thu, 22 Sep 2011 12:02:12 GMT

instead of into i had expected in.

Re: Replace error

former_member226519 — Thu, 22 Sep 2011 12:03:26 GMT

forgotten MODIFY ITAB?

Re: Replace error

Former Member — Thu, 22 Sep 2011 12:20:22 GMT

@Florian Kemmer - in is showing as syntax error

@Volker Binder - but before modify itab i need to modify wa..how to achieve that

Re: Replace error

Former Member — Thu, 22 Sep 2011 12:27:50 GMT

Hi,

This statement is obsolete, please check documentation for new REPLACE statement syntax...


1. REPLACE [{FIRST OCCURRENCE}|{ALL OCCURRENCES} OF] 
pattern 
IN [section_of] dobj WITH new 
[IN {BYTE|CHARACTER} MODE] 
[{RESPECTING|IGNORING} CASE] 
[REPLACEMENT COUNT rcnt] 
{ {[REPLACEMENT OFFSET roff] 
[REPLACEMENT LENGTH rlen]} 
| [RESULTS result_tab|result_wa] }.

Something like:


FIELD-SYMBOLS: <fs> TYPE ty_ch.
CONSTANTS: gc_pattern(100) TYPE c VALUE '<?xml versio = ...'.
LOOP AT itab ASSIGNING <fs>.
   REPLACE gc_pattern IN <fs>-data WITH space IN CHARACTER MODE.
ENDLOOP.

Kr,

Re: Replace error

Former Member — Thu, 22 Sep 2011 12:32:44 GMT

Hi,

Try this.



REPLACE ALL OCCURRENCES OF '- <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02">' 
IN v_data1-data WITH ' '.

Regards,

Danish.

Re: Replace error

Former Member — Thu, 22 Sep 2011 13:00:34 GMT

i m using 4.6 version...there is no " REPLACE ALL OCCURRENCES"

Re: Replace error

Former Member — Thu, 22 Sep 2011 13:05:30 GMT

OK then try something like:


FIELD-SYMBOLS: <fs> TYPE ty_ch.   "Type of you v_data1 structure
CONSTANTS: gc_pattern(100) TYPE c VALUE '<?xml versio = ...'.
LOOP AT itab ASSIGNING <fs>.
   REPLACE gc_pattern WITH space INTO <fs>-data.
ENDLOOP.

Re: Replace error

Former Member — Thu, 22 Sep 2011 13:23:55 GMT

No Manu...it is not working...

Re: Replace error

Former Member — Thu, 22 Sep 2011 14:10:42 GMT

Manu..canu let me know..if i need to add modify itab to below code to replicate to itab?

LOOP AT itab ASSIGNING <fs>.

REPLACE c1 WITH space INTO <fs>-data.

REPLACE c2 WITH space INTO <fs>-data.

REPLACE c3 WITH space INTO <fs>-data.

REPLACE c4 WITH space INTO <fs>-data.

REPLACE c5 WITH space INTO <fs>-data.

ENDLOOP.

Re: Replace error

Former Member — Thu, 22 Sep 2011 18:26:08 GMT

No you don't have to use the MODIFY statement since you're using a referenced field-symbol.

I think you miscreated your constant, sorry was'nt so clear about that... the length must be the exact length of the string enclosed..

I mean:


CONSTANTS: c1(15) TYPE c VALUE 'thisisaconstant'.  "Exact length = 15

Kr,

Re: Replace error

Former Member — Thu, 22 Sep 2011 18:40:37 GMT

I ran your original code and it worked fine. Are you sure your itab contains the strings?

Rob

Re: Replace error

Former Member — Thu, 22 Sep 2011 18:46:24 GMT

Yes the only thing missing in the original code was the modify statement...

But ugly to read

Re: Replace error

Former Member — Thu, 22 Sep 2011 18:54:05 GMT

But he got sy-subrc = 4 which tells me the string was not found.

Now that I think of it, the sy-subrc = 4 would apply to the last loop pass where the string was not found, so if the modify were added, it would likely work (assuming the strings are actually in prior records).

Rob

Re: Replace error

kesavadas_thekkillath — Fri, 23 Sep 2011 04:44:27 GMT

Hi,

Is your requirement to replace what ever comes in the tags <...> or are these strings fixed?

Keshav

Re: Replace error

Former Member — Fri, 23 Sep 2011 05:56:21 GMT

Hi,

Try this. This should work perfectly.



DATA: v1 TYPE string VALUE '- <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02">'.

LOOP AT itab INTO v_data1.
* Eg. v_data1-data = '- <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02"> test'.

  REPLACE v1 WITH space INTO v_data1-data.
  MODIFY itab FROM v_data1 TRANSPORTING data.
ENDLOOP.

OR...... A simpler example is given below.

DATA: v1 TYPE string VALUE '- <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02"> test'.
DATA: v2 TYPE string VALUE '- <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02">'.

REPLACE v2 WITH space INTO v1.

WRITE: / v1,
       / v2.

Regards,

Danish.

Re: Replace error

Former Member — Fri, 23 Sep 2011 06:40:12 GMT

Hi,

loop at itab into v_data1.

clear v_data1-data .

modify itab from v_data1-data index sy-tabix transporting v_data1-data .

clear v_data1.

endloop.

Ram.

Re: Replace error

Former Member — Fri, 23 Sep 2011 09:05:27 GMT

Thanks for ur help..it really helped...i have given exact length in the constants..

one more thing...now i want to add 1 line to the existing itab..exactly at the begining..and 1 at the end...

i have tried with append..it always append at the bottom..but i want to add at the begining of itab...

Re: Replace error

Former Member — Fri, 23 Sep 2011 09:25:47 GMT

Hi,

Try this for adding line at the beginning.

Create another Internal table say ITAB1 of the same type as ITAB. Clear and fill the existing work area i.e. v_data1.


APPEND v_data1 TO itab1.
APPEND LINES OF itab[] TO itab1[].

Regards,

Danish.

Re: Replace error

kesavadas_thekkillath — Fri, 23 Sep 2011 09:29:23 GMT

@OP - Please answer my previous question for my understanding. A simple regex statement might solve it.

@ danish


Try this for adding line at the beginning.
Create another Internal table say ITAB1 of the same type as ITAB. Clear and fill the existing work area i.e. v_data1.
APPEND v_data1 TO itab1.
APPEND LINES OF itab[] TO itab1[].

No need of such big logic...Just a insert with index 1 will do.

kesav