topic Re: Split and pick in Application Development and Automation Discussions

Split and pick

kiran_k8 — Thu, 22 Mar 2007 14:44:04 GMT

Hi Folks,

I need to pick the data from a field and dispaly it as two fields.Can anyone here let me know how to go with this.

addr1_data-remark:-(table is addr1_data and the field is remark).

now i have to pick the contents from the field "remark" of table "addr1_data",split it into two to fill in two fields namely registration and tax-id.

If I am confusing you with the fields and the content just let me know the way to split the data.

Points will be given.

K.Kiran.

Re: Split and pick

Former Member — Thu, 22 Mar 2007 14:54:42 GMT

you can split one field into two by using the SPLIT statment. but you will need a delimiter to use this statment

SPLIT addr1_data-remark at space into registration taxid.

in this case we are using SPACE as delimiter

for examlple if you have 'ABCDEF 12345' in the remark field. the split statement will split the data at SPACE and put 'ABCDEF' in the field registration and '12345' in the field taxid.

-Kalyan

Re: Split and pick

Former Member — Thu, 22 Mar 2007 14:55:39 GMT

What is the criteria for the split? The SPLIT command is the easiest if you are splitting the field at a specific character.

  SPLIT remark AT (something) INTO registration tax_id .

Otherwise you will have to do a bit of string manipulation, I guess?

Cheers

Lyal

Re: Split and pick

kiran_k8 — Thu, 22 Mar 2007 14:59:16 GMT

Kalyan,

What if that field has multiple spaces?

I mean if addr1_data-remark has the followding data:- kiran vijayawada 520003.

now i have to fetch "kiran vijayawada" into registration and 520003 into taxid.

as per your words the syntax should be--- SPLIT ADDR1_DATA-REMARK AT SPACE INTO REGISTRATION TAXID.Am I right?

Points given.

Thanks,

K.Kiran

Re: Split and pick

bryan_cain — Thu, 22 Mar 2007 15:14:42 GMT

Try this for multiple spaces. You'll need to fiddle with the data definitions. Theoretically you can just have the itab be made up of a single line of type string, but I kept getting an error and I don't have time to dig into why.


report ybctest.

PARAMETERS: text(50) TYPE c.

DATA: BEGIN OF itab OCCURS 0,
        line(20) type c,
      END OF itab.

data: test type string.

DATA: name(20) TYPE c,
      id(10) TYPE c.

SPLIT text AT space INTO TABLE itab.

LOOP AT itab.

  condense itab-line.
  test = itab-line.

  IF test CO '0123456789'.
    id = itab-line.
    DELETE itab.
  ENDIF.

ENDLOOP.

LOOP AT itab.
  CONCATENATE name itab-line INTO name SEPARATED BY space.

ENDLOOP.

WRITE: / 'name: ', name.
WRITE: / 'ID: ', id.

Re: Split and pick

Former Member — Thu, 22 Mar 2007 15:22:27 GMT

There has to be some rule as to how you are going to split it. Otherwise it will not be correct. It has to be either fixed length values or separated by something. If they are fixed length values, then all you have to do is to move the offsets


move: remarks+0(xx) to registration,
      remarks+yy(zz) to taxid.

If they are separated by something then split will work as others suggested.

Re: Split and pick

Former Member — Thu, 22 Mar 2007 15:57:18 GMT

Hi Kiran,

for things like spliting text, you should define a fixed structue whether two spaces or one space, You will not be able to handle all the cases generically. You can ask the users to enter the data in the remark field in a certain format. if they enter it right you can split it correctly, if they enter it wrong it will be at their own peril.

if possible as them to enter it this way ,

'Kiran vijayawada : 1234567' , this way you can split at the character ':' and get the data into the two fields.

- Kalyan

Re: Split and pick

olivier_segol — Thu, 22 Mar 2007 16:09:02 GMT

Hi,

If you are sure that your field is under this format: letters numbers, you shoul try to use TRANSLATE myText USING '0 1 2 3 4 5 6 7 8 9 '

all numbers will be replace by space, so you get the first part of the field. Get its lenght using strlen.

Then you can get the second part of the field using offset: myField+lengh_first_part(total_lenght)

Hope it will help you

Re: Split and pick

kiran_k8 — Fri, 23 Mar 2007 04:36:44 GMT

Hi Folks,

Thanks alot to everybody.I have one more question.

Addr1_data is a structure.So,I will not be able to retrieve any data from it.

But the screen field is Addr1_data-remarks.

I have to fetch the data given in this screen field.

Now I will be able to retrieve from it as it is not a table but a structure.The data entered in this screen field has to get stored in some or the other table,right?Now how to find where it is getting stored and then retrieving it.

I will try splitting the data as mentioned by you all.

Points given.

K.Kiran.

Re: Split and pick

Former Member — Fri, 23 Mar 2007 04:40:53 GMT

Hi Kiran,

chk the where-used-list of the field REMARK , u can get some some table , u can find out from that

Re: Split and pick

kiran_k8 — Fri, 23 Mar 2007 05:08:55 GMT

Bryan,

The code you have given is Sexy.It is working perfectly,but I have to do some fine tuning to fit that into my requirements.

Points given.

Thanks,

K.Kiran.

Re: Split and pick

kiran_k8 — Fri, 30 Mar 2007 03:54:38 GMT

problems solved