topic Re: Split function in Application Development and Automation Discussions

Split function

former_member215107 — Thu, 11 Sep 2008 15:59:12 GMT

How can i use Split function when i receive one of them:

Pim/Pam/Poum

Pim;Pam;Poum

Pim Pam Poum

To separate Pim, Pam and Poum i can have a different special character ...

Thanks for your help

Rodolphe.

Re: Split function

Former Member — Thu, 11 Sep 2008 16:10:16 GMT

HI,

You can Use This code.

If var_String CA '/'.

split var_string AT '/' into var1 var2 var3.

Elseif Var_string CA ','.

Elseif var_string CA space.

Endif.

Regards

Sumit Agarwal

Re: Split function

Former Member — Thu, 11 Sep 2008 16:14:22 GMT

Can the string have all of ' ;/' in the same string?

Rob

Re: Split function

Former Member — Thu, 11 Sep 2008 16:16:23 GMT

Use CA

DATA : W_STRING TYPE STRING.

W_STRING = 'Pim/Pam/Poum'.

IF W_STRING CA '/: ( Place all the special characters here )' .

WRITE SY-FDPOS.

using sy-fdpos write the letter then split by it.

ENDIF.

Re: Split function

Former Member — Thu, 11 Sep 2008 16:18:06 GMT

SPLIT string AT DELIMITER INTO ONE TWO THREE.

Re: Split function

Former Member — Thu, 11 Sep 2008 16:26:18 GMT

DATA : W_STRING TYPE STRING,

split_char type c,

var1 type string,

var2 type string,

var3 type string.

W_STRING = 'Pim:Pam:Poum'. ( Try replcaing the special character )

IF W_STRING CA '/:;$%@!' ( If the special character is not included in the quotes pls include ) .

split_char = w_string+sy-fdpos(1).

split w_string at split_char into var1 var2 var3.

write : var1, var2 , var3.

ENDIF.

output :

Pim Pam Poum

Re: Split function

valter_oliveira — Thu, 11 Sep 2008 16:38:49 GMT

In each record you don't know what is the separator, but in the entire record it's the same, right? So you can try something like this:


DATA: char TYPE char1.
IF <your_string> CA '/'.
  char = '/'.
ELSEIF <your_string> CA ';'.
  char = ';'.
ELSE.
  char = ' '.
ENDIF.
SPLIT <your_string> AT char INTO <var1> <var2> <var3>.

Regards.

Valter Oliveira.