1 Reply Latest reply on Jul 9, 2018 1:04 PM by Jim Dehner

    Extract Date from File name

    aravind.sunkara

      Hi,

       

      I am new to tableau prep....I have a situation where I need to extract date which is in my file name...

       

      Eg: Book1 06-15-2018.xlsx, Book1 07-27-2018.xlsx

       

      I want to do a wild card union and in the first step I want to extract date from the file....

      How can I do that???

       

      Someone help me...

       

       

      Thanks,

      SA.

        • 1. Re: Extract Date from File name
          Jim Dehner

          Hi see below

           

          I had a text folder with 3 files

           

          I loaded July into Tableau

           

           

           

          then to get the other files

           

           

           

           

          then select apply

          and the files are loaded

           

           

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.