topic Re: how to replace a number from string? in Application Development and Automation Discussions

how to replace a number from string?

former_member220941 — Mon, 29 Sep 2014 14:01:39 GMT

Dear All,

I have below requirement can any one plz help me.

In this below string i want to remove GB it is country key and this key is dynamic .how to remove it ?

DATA : L_var1 TYPE string .

l_var1 = ' Ledger 0L VAT reg.no.: GB602372281 RFASLM00/SAPUSER Page 1'.

Thanks,

Raj.

Re: how to replace a number from string?

Former Member — Mon, 29 Sep 2014 14:07:14 GMT

would you always have "VAT reg.no.:" preceding it?

Re: how to replace a number from string?

former_member188724 — Mon, 29 Sep 2014 14:17:06 GMT

Hi Raj,

How you populate the vat reg in the string. You may move the value from databse selection and move it to string by concatenation.

If so then while concatenating VAT REgNO & the value you can remove the Country key by checking if the VAT no CA 'ABCD.....Z' then do not concatenate that part to the string.

Hope it helps.

Regards,

K.S

Re: how to replace a number from string?

Former Member — Mon, 29 Sep 2014 14:20:52 GMT

1. Use SPLIT statement to split your string at ':'

Like SPLIT lv_var1 into l_split_1 l_split_2 at ':'.

2. In your second temporary variable you will have l_split_2 = GB1234567

3. l_var3 = l_split_2+2(10). " this will pass your digits of VAT no.

4. Concatenate l_split_1 l_var3 into l_final.

This is just an idea how you can achieve it.

Re: how to replace a number from string?

former_member220941 — Mon, 29 Sep 2014 14:35:47 GMT

Except GB everything is remains same.

BR,

Raj.

Re: how to replace a number from string?

GirieshM — Mon, 29 Sep 2014 14:39:28 GMT

Hi Raj,

Try this,

REPORT ztezt.

DATA text TYPE string VALUE 'I know you know GB602372281 RFA'.

DATA: text1 TYPE string,

text2 TYPE c LENGTH 48,

off TYPE i,

lv_len TYPE i,

len TYPE i.

lv_len = strlen( text ).

FIND 'GB' IN text MATCH OFFSET off

MATCH LENGTH len.

REPLACE SECTION OFFSET off LENGTH len OF:

text WITH ' '.

lv_len = lv_len - off.

lv_len = lv_len - 2.

SPLIT text+off(lv_len) at space into text1 text2.

WRITE: text.

Re: how to replace a number from string?

Former Member — Mon, 29 Sep 2014 14:42:47 GMT

check for VAT reg.no. using CS and then pick up offset using Sy-fdpos then sy-fdpos+lengthof (VAT reg.no.) and this would be teh position where your country key starts, you can now remove it.

Re: how to replace a number from string?

former_member220941 — Mon, 29 Sep 2014 15:10:36 GMT

GB is not constant it is dynamic...it may be IN or US or DE like that..

Re: how to replace a number from string?

GirieshM — Mon, 29 Sep 2014 15:17:19 GMT

Hi Raj,

Try any of the 3 steps:

1. The offset of the Country code is it constant?. i.e., it always comes at 16th position for example. If so try to hard code offset directly.

2. check you might find his country code in local or global variables. Based on that you can change your Find syntax.

3. You have to find the company code from respective table based on key and write the syntax based on that.

With Regards,

Giriesh M

Re: how to replace a number from string?

former_member188724 — Mon, 29 Sep 2014 19:32:13 GMT

Hi Raj,

As you say all are no's except GB or can be any other country.

Declare a variable of type numeric,

move the contents of the vat which contains GB123456.

then it will contai only nos without country, provided all nos will come after GB, i.e.,GB doesn't come in between no's.if the format is different please send the possible formats.

Hope this helps.

Regards,

K.S

Re: how to replace a number from string?

former_member156446 — Mon, 29 Sep 2014 20:14:34 GMT

data: lv_vat type string value 'GB602372281'.

replace all occurance of sy-abcd in lv_vat by space.

condence lv_vat.

Re: how to replace a number from string?

Former Member — Tue, 30 Sep 2014 08:08:47 GMT

You need to first define how to recognize country key before trying to remove it.

I am assuming that it would be first 2 alphabets that appear right after string ' VAT reg.no.: ' and I am replacing only the first occurrence.

Have a look at this snippet.

DATA str TYPE string
  VALUE 'Ledger 0L  VAT reg.no.: GB602372281  RFASLM00/SAPUSER'.
REPLACE REGEX '(?:VAT reg.no.: )[a-zA-Z]{2}' IN str WITH ''.
WRITE str.

Re: how to replace a number from string?

former_member220941 — Tue, 30 Sep 2014 09:15:18 GMT

Thanks a lot Manish it is working fine..... .

Regards,

Raj.