Skip to Content
0
Former Member
Dec 27, 2007 at 01:31 AM

Read file by delimiter

148 Views

I have a program which will read a text file and put the data into a internal table, the snipple code as the follows, but it only can extract the data and put it into internal table by tab delimiter. if the data is separator by comma, it can not read properly, How can i read the file by comma delimiter. Thanks!

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = wa_file

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = temp_file_record

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.