3 Replies Latest reply on Sep 12, 2018 12:55 PM by Joshua Milligan

    Extracting a string from a field name to use as a date

    Karen Wallace

      Hello,

       

      Just started using Prep and it's fantastic!

       

      This seems like a pretty straightforward ask but I'm just not getting the correct output.

       

      Inheriting a data set, there are column names that are like this "Result (201312)" - the good news is it's always the word "Result" followed by the parentheses YYYYMM parentheses.

       

      Ultimately, I'm trying to extract the YYYYMM value in the hopes of converting this into a more meaningful date format (YYYYMMDD, for ex.)

       

      When I use the FIND function for the last parentheses I know it's always in position 0 but then stumbling with trying to use the MID function to parse out the rest.

       

      Any help much appreciated!

       

      Karen