Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamic Data Source file name

Hi, 

 

I have a daily data source file that requires accessing, however each the name of the source file itself is different with a new datetime stamp appended at the end:

 

For example each the file has the following name followed by the YYYY-MM-DD-HH-MM-SS:

 

DELIVERY ADDRESS & TYPE PP32024-02-04-14-25-00

DELIVERY ADDRESS & TYPE PP32024-02-05-14-25-08

DELIVERY ADDRESS & TYPE PP32024-02-06-14-25-07

 

Is there a way of using a "contains" to reference the first part of the source file so that it is dynamic for all future files?

If so, how do I write this code?

 

Thanks!

Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous Load the files as a folder, and there before expand of binary data you can filter data using contains

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks Amit. However, this didn't seem to work for the text.contains function or I was doing it wrong.. As it is a cumulative file of records I found another solution which works and allows the new file to replace the previous day's one without explicit reference.