topic help with field in Application Development and Automation Discussions

help with field

Former Member — Wed, 16 May 2007 06:25:50 GMT

hallow

i have a field name like orgeh

and in this field i have value like 12345abc99912345

and i wont to remove from this field <b>abc999</b>

that i have after just 1234512345

how can i do that?

regards

Former Member — Wed, 16 May 2007 06:28:31 GMT

Hi,

use command :

concatenate orgeh1(5) orgeh10(5) into orgeh. "check offsets

Jogdand M B

Former Member — Wed, 16 May 2007 06:33:15 GMT

Hi!

You can use this:

DATA: str TYPE string VALUE '12345aaa99912345',

st1 TYPE string,

st2 TYPE string.

SPLIT str AT 'aaa999' INTO st1 st2.

CONCATENATE st1 st2 INTO str.

Former Member — Wed, 16 May 2007 06:33:37 GMT

Hi Antonio,

Use this code:

Replace 'abc999' in orgeh with ''.

Condense orgeh.

Regds,

Younus

<b>Reward Helpful Answers!!!</b>

Former Member — Wed, 16 May 2007 06:34:55 GMT

Hai,

U can do by this,

Data : text(16) type c value '12345abc99912345',

p1(5) type c,

p2(7) type c.

split text at '9' into p1 p2.

shift p2 by 2 places left.

write : p1.

write : / p2.

concatenate p1 p2 into text.

write : / text.

Regards,

Padmam.