Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago
Solved

Extracting date from source source.name text

Hello, I have folder with multiple files.

 

names are consistent and numbers represent week ending date. For example 240324 is 24/03/2024.

I was trying to extract date since I need to keep only latest file from the list.
For from this list latest file is 'REPORT spsf We-240324.xlsx' , if possible I would like it to always choose latest file available since list would be getting updated weekly.

If it is not possible then to allow files in certain date range. For example files from 01/04/2024 - 31/03/2025

Anyone know how I could do that?

Thanks

 

Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    Justas4478 

    You can use the below code and create a custom column. (Paste the below code in custom column window and replace the [Data] with your column name.

    #date(Number.From("20" & Text.Range(Text.BetweenDelimiters([Data], "-","."),4,2) ), Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),2,2)) ,Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),0,2)))

     


    If the post helps please give a thumbs up


    If it solves your issue, please accept it as the solution to help the other members find it more quickly.


    Tharun

     

2 Replies

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    Justas4478 

    You can use the below code and create a custom column. (Paste the below code in custom column window and replace the [Data] with your column name.

    #date(Number.From("20" & Text.Range(Text.BetweenDelimiters([Data], "-","."),4,2) ), Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),2,2)) ,Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),0,2)))

     


    If the post helps please give a thumbs up


    If it solves your issue, please accept it as the solution to help the other members find it more quickly.


    Tharun