topic Re: function in Application Development and Automation Discussions

function

Former Member — Fri, 25 Jul 2008 05:21:01 GMT

hi Experts,

when we use function FAA_FILE_UPLOAD_EXCEL for upload excel to internal table what will be the value for

parameter I_DELIMITER for TAB delimiter

Thanx

Re: function

Former Member — Fri, 25 Jul 2008 05:27:32 GMT

hi,

better use this i too faced problem with that

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = p_pfile

i_begin_col = 1

i_begin_row = 2

i_end_col = 13

i_end_row = 8

TABLES

intern = it_excel

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Re: function

Former Member — Fri, 25 Jul 2008 05:28:29 GMT

Hi Rohan.

I would like to suggest,

For a TAB Delimiter the value is

",,"

that is two Commas.

That gives a TAB.

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

Re: function

Former Member — Fri, 25 Jul 2008 05:30:24 GMT

Instead of FAA_FILE_UPLOAD_EXCEL use FM ALSM_EXCEL_TO_INTERNAL_TABLE

As inside FM FAA_FILE_UPLOAD_EXCEL .. ALSM_EXCEL_TO_INTERNAL_TABLE no need to give tab delimeter

In case you are not aware of its parameters you can revert back

Regards

Hitesh

Re: function

Former Member — Fri, 25 Jul 2008 05:32:34 GMT

HI,

It will be

", ,"

i.e 2 commas seperated by SPACE.

It is the interal presentation of TAB.

Regards,

Anirban

Re: function

former_member217544 — Fri, 25 Jul 2008 05:39:53 GMT

Hi Rohan,

You can use the floowign class attributes for delimiters.

for example:

constant :

c_tab value cl_abap_char_utilities=>HORIZONTAL_TAB.

and pass this c_tab to the function module parameter I_DELIMITER.

Not only for tab delimiter, this class contains newline, carriage return, pagebreak etc...

Hope thsi will help.

Regards,

Swarna Munukoti.

Re: function

Former Member — Sat, 26 Jul 2008 05:19:49 GMT

Thanx Swarna,

Its not working , its take # as delimenater not tab,

pls give me another solution,

pls reply ASAP.

Thanx & Rgds

Rohan

Re: function

Former Member — Sat, 26 Jul 2008 05:34:30 GMT

use GUI_UPLOAD , First save the File as Tab Delimited Text file. and then upload using GUI_UPLOAD

HAS_FIELD_SEPARATOR    =  'X'

Re: function

Former Member — Sat, 26 Jul 2008 16:10:07 GMT

defaultly it is ','

but for tab delimited file we should pass 'X'.

Re: function

Former Member — Mon, 28 Jul 2008 05:51:48 GMT

Hey guys ,

i m asking about FAA_FILE_UPLOAD_EXCEL function not for gui_upload,

Thanx

Re: function

former_member217544 — Mon, 28 Jul 2008 06:14:51 GMT

Hi Rohan,

All the unidentified characters like backspace, formfeed, tab, newline will be shown as "#" by default. This "#" is different from real "hash - # ", SAP will take care of this internally and manipulates as per the constant you declared .

Try uploading the excel file and use the split statement with horizontal tab and check in debug mode.

If you check ony the value of c_tab the it will show as "#" only( please make a note that this "#" is different from the original "hash '# " ) .Try debugging till the point of split.

Hope this will help.

Regards,

Swarna Munukoti.

Re: function

Former Member — Thu, 25 Sep 2008 07:16:57 GMT

THANX