topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Fri, 08 Dec 2006 11:29:45 GMT

Dear gurus,

i am having an input with 001, 002 in the same field (text) .

I want to seperate this field into two by identifyung the comma

i thas to be like this now

reason id = 001

counter = 002

How shall i do this with query

Thanx in advance

senthil

Former Member — Fri, 08 Dec 2006 11:31:47 GMT

hi,

Use the Split command ,

split text1 at ',' into test2 test3.

Reagrds

Arun

Manohar2u — Fri, 08 Dec 2006 11:31:54 GMT

SPLIT f AT g INTO h1 ... hn.

SPLIT NAMES AT ',' INTO ONE TWO THREE

Former Member — Fri, 08 Dec 2006 11:35:57 GMT

SPLIT V_TAXT AT ',' INTO V_REASONiD V_COUNTER.

Former Member — Fri, 08 Dec 2006 11:45:47 GMT

hi ,

we can do this in 2 way.

using split command.

data: text1(11) type c value '100,200',

text2(5) type c,

text3(5) type c.

split text1 at ',' into test2 test3.

using offset.

data: text1(11) type cvalue '100,200',

text2(5) type c,

text3(5) type c,

len type i.

offset type i.

len = strlen( text1 ).

do len times.

if text1+sy-index(1) = ','.

offset = sy-index - 1.

text2 = text1+1(offset).

offset = sy-index + 1.

text3 = text1+offset(5).

endif