topic Re: Split statement separating by comma in Application Development and Automation Discussions

Split statement separating by comma

Former Member — Wed, 31 Mar 2010 04:49:56 GMT

I am my data in tdines..........

i am having two fields data in single line separated by comma.

Now i moved tdlines data to V1.

i have to use split statemnt by using comma so that it should get in to V2 and V3

EX: 1234a,65432a

this is tdlines.

i have moved that to V1.

so V1 = 1234a,65432a

I wanted to get

V2 = 1234a

V3 = 65432a

Please tell the syntax

Re: Split statement separating by comma

Former Member — Wed, 31 Mar 2010 04:55:18 GMT

split text1 at var into table it_text. " chops the string at value in "var"(put ',' in this var) and puts sequentially in table it_text(field shud b char)

or

split text1 at var into text1 text2 text2.   " into individual variables

regards,

Sumit

Edited by: Sumit Nene on Mar 31, 2010 6:57 AM

Re: Split statement separating by comma

Former Member — Wed, 31 Mar 2010 04:55:38 GMT

Hello


split V1 at ',' into V2 V3.

Re: Split statement separating by comma

Former Member — Wed, 31 Mar 2010 05:36:10 GMT

Split V1 at ',' into v2 v3.

Regards

Vinod

Re: Split statement separating by comma

Former Member — Wed, 31 Mar 2010 06:00:24 GMT

Use like this

SPLIT V1 AT ',' INTO V2 V3.

Re: Split statement separating by comma

praveen_hannu — Wed, 31 Mar 2010 06:10:34 GMT

Use Split Command

 split v1 at ',' into v2 v3.

Re: Split statement separating by comma

Former Member — Wed, 31 Mar 2010 06:26:49 GMT

This is the syntax.

SPLIT dobj AT sep INTO

{ {result1 result2 ...}

So you can code like this .

c_comma = ','.

SPLIT var AT c_comma INTO: v1 V2.

Re: Split statement separating by comma

Sathya_Gunasekaran — Wed, 31 Mar 2010 06:41:21 GMT

Split V1 at ',' into V2 V3.

Edited by: Sathya Gunasekaran on Mar 31, 2010 8:42 AM