topic Re: replace comma (delimiter) by tab. in Application Development and Automation Discussions

replace comma (delimiter) by tab.

Former Member — Fri, 09 Feb 2007 13:39:41 GMT

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.

Re: replace comma (delimiter) by tab.

Former Member — Fri, 09 Feb 2007 13:41:54 GMT

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

Re: replace comma (delimiter) by tab.

Former Member — Fri, 09 Feb 2007 13:45:47 GMT

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

Re: replace comma (delimiter) by tab.

Former Member — Fri, 09 Feb 2007 13:48:19 GMT

HI..

I DID NOT GET WHAT U SAID....

MY CONCATENATE STATEMENT IS AS FOLLOWS.

CONCATENATE T_MAIN-WERKS ',' STRING INTO STRING.

THX.

Re: replace comma (delimiter) by tab.

Former Member — Fri, 09 Feb 2007 13:50:31 GMT

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