2 Replies Latest reply: Apr 3, 2013 3:30 AM by Sayak Roy RSS

    To get a string in the braces, eg: (abcdd)Tempid, I want only 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...