topic Re: converting the comma seperator value format in Application Development and Automation Discussions

converting the comma seperator value format

Former Member — Thu, 25 Jan 2007 03:06:37 GMT

i am getting the content of a table in a internal table with comma separator value format, dynamically by using dfies table i am getting the header of the table, and displaying it in the output, now my query is that the content of the data which i am getting in a itab having only one field of type string

data : begin of itab occurs 0,

data1 type string,

end of itab.

some where they were concatenating the content of the data and storing it inthe itab, now i want the content of the itab should be displayed corresponding to there header in the output

Re: converting the comma seperator value format

Former Member — Thu, 25 Jan 2007 03:16:57 GMT

Hi Santosh

Try using TAB as separator for data to display accordingly.

Eg: tab(1) type c value cl_abap_char_utilities=>horizontal_tab.

Kind Regards

Eswar

Re: converting the comma seperator value format

Former Member — Thu, 25 Jan 2007 03:26:31 GMT

Hi Santosh ,

You can use the command SPLIT to split the string into smaller sections.

Do revert back in case you have further queries.

Regards

Arun

Re: converting the comma seperator value format

Former Member — Thu, 25 Jan 2007 03:29:24 GMT

Hi Santosh,

You can remove the commas from the record by using the REPLACE command as below -

LOOP AT itab.

DO.

REPLACE ',' WITH '' INTO itab-data1.

IF sy-subrc NE 0.

EXIT.

ENDIF.

ENDDO.

ENDLOOP.

Reward points if found useful...!

Cheers

Abhishek