Regarding the file name checking

Former Member — Wed, 13 Jun 2007 06:36:56 GMT

Hi ,

I m using the below program which will upload the XL sheet , here i want to validate the file name which i m selecting from the destop. the file name should be named as "Suresh.XLS", where and how i can do validation for checking the file name..

I gave the code for the refernce...

please let me know the solution ASAP..

REPORT ZSURESH13062007 .

types: begin of ttab ,

fld1(30) type c,

fld2(30) type c,

fld3(30) type c,

fld4(30) type c,

fld5(30) type c,

end of ttab.

data: itab type table of ttab with header line.

selection-screen skip 1.

parameters: p_file type localfile .

selection-screen skip 1.

at selection-screen on value-request for p_file.

call function 'KD_GET_FILENAME_ON_F4'

exporting

static = 'X'

changing

file_name = p_file.

start-of-SELECTION.

IF p_file IS INITIAL.

MESSAGE S398(00) WITH 'No input file specified.'.

ELSE.

clear itab.

refresh itab.

PERFORM upload_data.

loop at itab.

write:/ itab-fld1, itab-fld2, itab-fld3, itab-fld4, itab-fld5.

endloop.

endif.

form upload_data.

data: file type rlgrap-filename.

data: xcel type table of alsmex_tabline with header line.

file = p_file.

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'

exporting

filename = file

i_begin_col = '1'

i_begin_row = '1'

i_end_col = '200'

i_end_row = '5000'

tables

intern = xcel

exceptions

inconsistent_parameters = 1

upload_ole = 2

others = 3.

loop at xcel.

case xcel-col.

when '0001'.

itab-fld1 = xcel-value.

when '0002'.

itab-fld2 = xcel-value.

when '0003'.

itab-fld3 = xcel-value.

when '0004'.

itab-fld4 = xcel-value.

when '0005'.

itab-fld5 = xcel-value.

endcase.

at end of row.

append itab.

clear itab.

endat.

endloop.

ENDFORM.

Thanks,

Suresh...

Re: Regarding the file name checking

Former Member — Wed, 13 Jun 2007 06:44:34 GMT

Hi Suresh,

Check the Function Modules,

PC_CHECK_FILENAME_WITH_EXT,

PC_CHECK_FILENAME.

Thanks,

Reward If Helpful.

topic Re: Regarding the file name checking in Application Development and Automation Discussions

Regarding the file name checking

Re: Regarding the file name checking