function

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

HI,

It will be

", ,"

i.e 2 commas seperated by SPACE.

It is the interal presentation of TAB.

Regards,

Anirban

[former_member217544]

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.

[Former Member]

Thanx Swarna,

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

pls give me another solution,

pls reply ASAP.

Thanx & Rgds

Rohan

[Former Member]

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

HAS_FIELD_SEPARATOR    =  'X'

[Former Member]

defaultly it is ','

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

[Former Member]

Hey guys ,

i m asking about FAA_FILE_UPLOAD_EXCEL function not for gui_upload,

Thanx

[former_member217544]

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.

[Former Member]

THANX