Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

GUI_UPLOAD problem.....

Hi all,

i have a problem i.e am uploading flat file using gui_upload, in my file field seperator is pipe symbal, after uploading am getting values into internaltab with pipe symbal, here i want to do calclations on that values, so i dont want pipe symbal, how to avoid,

my FM is.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = l_str_upload

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = ''

DAT_MODE = 'X'

TABLES

DATA_TAB = it_input

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17 .

IF SY-SUBRC <> 0.

call function '/MSG/R_BAPI_CREATE_ERRORMSG'

exporting

p_msgtype = sy-msgty

p_msgid = sy-msgid

p_msgno = sy-msgno

p_msgpar1 = sy-msgv1

p_msgpar2 = sy-msgv2

p_msgpar3 = sy-msgv3

p_msgpar4 = sy-msgv4

tables

p_t_return = lt_return.

ENDIF.

if not ( lt_return[] is initial ).

loop at lt_return into ls_return.

append ls_return to lt_return_all.

endloop.

clear lt_return.

endif.

**************

here 1st few fields of my input file. is.

BRANCH|XRE_TTY|ORIG_CURR|ORIG_AMT

S|S-FFF-P-96-0193-96|AED|314319.53

S|S-FNM-P-96-0194-96|USD|8031.79

S|S-EEB-P-92-0365-92|PKR|2048.80

S|S-EEB-P-92-0365-93|PKR|78992.77

so how get values without pipe.

thanks in advance.

murali.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question