Skip to Content
0
Former Member
May 21, 2018 at 02:23 PM

Get file name from SAP Data service

331 Views

Hi, I'm unable to read file name from data services which contain date_time format, I can read date but time can be variable, I've tried with *.csv on file name(s) property for flat file, but this for static file name.

Example of files: File_20180520_200003.csv, File_20180519_192503.csv, etc.

My script:

$Filename= 'File_'|| to_char(sysdate()-1, 'YYYYMMDD')|| '_'|| '*.csv'; 

I want to find a solution to read the 6 digits (any number) *.

Thanks