replace comma (delimiter) by tab.

[Former Member]

HI..

IN MY PROGRAM I HAVE COCATENATED ALL THE WERKS(PLANTS) FOR A GIVEN MATNR INTO A SINGLE STRING VARIABLE. I WANT TO REPLACE ALL MY COMMAS BY TAB, SO THAT WHEN I DOWNLOAD IT USING GUI DOWNLOAD I WOULD GET DIFFERENT COLOUMNS IN THE EXCEL SHEET.

IS THERE ANY FUNCTION MODULE FOR IT????

IS IT POSSIBLE TO DECIDE THE NUMBER OF COLOUMNS AND THIER TYPE DYNAMICALLY FOR AN INTERNAL TABLE???

REGARDS.

SIDDHESH.

[Former Member]

Hi Siddesh,

When concatenating concatenate separated by

CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB

This is the best way, when downloading into the excel, it will split the columns properly.

Regards,

Aditya

[Former Member]

HI..

I DID NOT GET WHAT U SAID....

MY CONCATENATE STATEMENT IS AS FOLLOWS.

CONCATENATE T_MAIN-WERKS ',' STRING INTO STRING.

THX.

[Former Member]

Hi Siddhesh,

All you do it now put the statement as:

CONCATENATE T_MAIN-WERKS STRING INTO STRING

SEPARATED BY CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

That should do it, try and let me know.

Rgds,

Adity

[Former Member]

Hi,

You have an option in the program itself, there is no need to call a Function module, Presds the Find button(Binacular) and there you have an option to replace, so give the replace option there.

For internal table, you need to create a Dynamic internal table, to know this, please search the forum, you will find lot of answers

Regards

Sudheer