topic Re: move values from a string variable into a structure in Application Development and Automation Discussions

move values from a string variable into a structure

Former Member — Wed, 13 Nov 2019 09:08:13 GMT

how to move values from a string variable into a structure (not string) in the corresponding cells?

the string variable contains values extracted from a file .csv

for example the string variable contains:

FP02;LF;FP01

Re: move values from a string variable into a structure

Former Member — Wed, 13 Nov 2019 09:16:33 GMT

Use below statement

SPLIT <L_VARIABLE> AT ';' INTO <WA-VAR1> <WA-VAR2> <WA-VAR3> etc....

Re: move values from a string variable into a structure

Former Member — Wed, 13 Nov 2019 10:25:20 GMT

thanks.

one method more fast for transfer into structure or table?

whitout doing : <WA-VAR1> <WA-VAR2> <WA-VAR3> etc....

but directly transfer the data to corrispondent cells

for example: SPLIT <L_VARIABLE> AT ';' INTO <war>

Re: move values from a string variable into a structure

Tomas_Buryanek — Wed, 13 Nov 2019 10:35:30 GMT

Warning! This completely ignores CSV delimiters.

Re: move values from a string variable into a structure

Tomas_Buryanek — Wed, 13 Nov 2019 10:38:27 GMT

If it is CSV, then I recommend to use cl_rsda_csv_converter - csv_to_structure method.

In constructor you will need to set separator to ";" instead of initial "," (and maybe delimiter if you know it).

Re: move values from a string variable into a structure

Former Member — Wed, 13 Nov 2019 13:57:43 GMT

but I have to create the object with cl_rsda_csv_converter=>create ?

Re: move values from a string variable into a structure

FredericGirod — Wed, 13 Nov 2019 14:00:19 GMT

SE24 cl_rsda_csv_converter

there is two constructor : CONSTRUCTOR or CLASS_CONSTRUCTOR

create is not a constructor, it is a "simple" method.

search for example, if you fill unconfortable with these constructors

Re: move values from a string variable into a structure

Tomas_Buryanek — Wed, 13 Nov 2019 14:14:00 GMT

luca.treva yes I meant this method. You need to use it to create a object. You can find examples on the internet (or maybe in your system) how to use this class.

Re: move values from a string variable into a structure

Former Member — Wed, 13 Nov 2019 15:11:09 GMT

have you a pratical example please?

Re: move values from a string variable into a structure

Tomas_Buryanek — Wed, 13 Nov 2019 15:28:16 GMT

luca.treva Did you search? It is VERY simple:

DATA(lo_csv_converter) = cl_rsda_csv_converter=>create(
                               i_delimiter = l_delimiter
                               i_separator = l_separator ).

LOOP AT lt_csv_lines INTO l_csv_line.
  lo_csv_converter->csv_to_structure(
    EXPORTING
      i_data   = l_csv_line "Your string
    IMPORTING
      e_s_data = ls_data ). "Your result structure
ENDLOOP.