UNSTRING the First occurence Alone

rathinakarthik · New User Joined: 25 Jul 2006 Posts: 22

Hi,

I have a string
Say Str1 = 'a,b,c,d,e'

I want to split this into two variables based on comma as separator. The values of two variables need to be

Var1 = 'a'
Var2 = 'b,c,d,e'

Again i have to take var2 and split based on comma into 'b' and 'c,d,e' and similarly it goes on.

I used UNSTRING to try this

UNSTRING Str1
DELIMITED BY ','
INTO VAR1, VAR2
END-UNSTRING

But the values i got are
Var1 = 'a'
Var2 = 'b'

I need value of var2 as 'b,c,d,e'
Can we prevent Unstring option from delimiting the receiving field?
I want to Delimit based in First occerenc alone
Is there any Option for this. Please advise

Thank you

Bharath Bhat · Posted: Thu Apr 24, 2008 6:27 pm Post subject:

Hi,

Could you please post declarations of var1 and var2.

rathinakarthik · New User Joined: 25 Jul 2006 Posts: 22

Hi,

var1 will be pic x(1)
var2 will be pix x(20)

Thanks

ashimer · Posted: Thu Apr 24, 2008 7:10 pm Post subject:

try this way ...

var1 pic x(1)
vart pic x(1)
var2 pic x(20)

UNSTRING Str1
INTO VAR1, VART, VAR2
END-UNSTRING

after this stmt ull get a in var1 comma in vart and b,c,d,e in var2

now move var2 to str1 and do the following steps again for b,c,d,e

try and let us know ...

thanks
ashimer

dick scherrer · Posted: Thu Apr 24, 2008 9:18 pm Post subject:

Hello,

dick scherrer · Posted: Thu Apr 24, 2008 9:55 pm Post subject:

Hello again,

If you really wanted to unstring the first comma-delimited value into a variable and all of the other values into a second variable you could use: