3 Replies Latest reply: Apr 2, 2013 2:46 AM by Kaushik Solanki RSS

    To get a string in the braces, eg: (abcdd)Tempid, I want abcdd as an outcome...

      Hi

       

      To get a string in the braces, eg: (abcdd)Tempid

       

      I used

       

      LOAD SubField(Name,'(',2) as Name_Der

       

      FROM Data.xlsx (ooxml, embedded labels, table is Sheet1);

       

      However this is giving the entire string as abcdd)Tempid, I need only abcdd as an out come, Please help me out...