topic Re: how to separate the data ? in Application Development and Automation Discussions

how to separate the data ?

Former Member — Wed, 17 Jun 2009 15:54:38 GMT

Hi Friends,

After CONCATENATE my value is u2018p12345000u2019.

I want to separate last 3 character( 000 ).

Please guide me how to separate last 3 character from the u2018p12345000u2019.

Thanking you friends.

Subash

Re: how to separate the data ?

Former Member — Wed, 17 Jun 2009 15:58:02 GMT

Hi,

Incase you know the field length then just use offset.

If you do not know the field length then first determine the field length using STRLEN and the use offset.

for eg.

var1 = p12345000

var2 = var1+5(3).

Regards,

Ankur Parab

Re: how to separate the data ?

former_member229729 — Wed, 17 Jun 2009 16:07:54 GMT

Hi Subash,

You can use the below given logic.

The value can be of any length. The below given code gives you the last 3 characters only:


Data: v1 type string. 
Data: vlen type i,
         vstart type i.

v1 = u2018p12345000u2019.
vlen = strlen( v1 ).
vstart = vlen - 3.
write: v1+vStart.

Rgds,

Ramani N

Edited by: Ramani Nagarajan on Jun 17, 2009 6:12 PM

Re: how to separate the data ?

Former Member — Wed, 17 Jun 2009 16:10:17 GMT

Hi Ankur,

Thanking u .

But that field value is always not constant .

So how to separate always last 3 value only ?

Thanking you friends.

Subash

Re: how to separate the data ?

Former Member — Wed, 17 Jun 2009 16:17:26 GMT

Hi,

try this way to separeate the last three values irrespective of lenght..



Data: v1 type string. 
Data: vlen type i,
         vstart type i.
 
v1 = u2018p12345000u2019.
vlen = strlen( v1 ).
vstart = vlen - 3.

w_value = v1 + vstart ( 3).   "Now the w_Value contains last three values of a string

Regards,

Prabhudas

Re: how to separate the data ?

tarangini_katta — Wed, 17 Jun 2009 16:31:03 GMT

Hi,

Try this,

data : a(10) type C,

b(10) type C,

c(20) type C,

d(13) type c.

a = '1234'.

b = '123abc'.

concatenate a b into c.

d = C+7(10).

write d.

it will defintely work for u.

Thanks

Re: how to separate the data ?

Former Member — Thu, 18 Jun 2009 02:40:56 GMT

Hi Subash,

I feel Simple Shift if very helpful for your case...

Simple you can use the Shift command also,,,,

Example :

SHIFT ALPHA1 BY FIVE PLACES.

SHIFT ALPHA2 RIGHT BY 2 PLACES.

Just use F1 Help for Shift.

Thanks & regards,

Dileep .C

Re: how to separate the data ?

Former Member — Thu, 18 Jun 2009 03:33:52 GMT

Hi Dileep Kumar ,

Thank you for your best answer.

Thanking all of U.

Warm regards,

Subash