8 Replies Latest reply: Jul 24, 2014 10:22 AM by Joseph Simmons RSS

    Index, Left/Right

      Hi all,

       

      I'm trying to do recover some dates in my script but I don't know What function would best fit with my problem : Left/right, Index?:


      Ex :

      If 20140302_011 then 20140302

      If 39_204140302_011 then 20140302

      If 20_2_20120515_001 then 20120515

      If TEST_20120703_001 then 20120703

       

      These are the only the 4 occurences.

       

      I'd be greaful for any help.

       

      Many thanks,

       

      Florian