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



      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!