To get a string in the braces, eg: (abcdd)Tempid
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...
LOAD Textbetween(Name,'(',')') as Name_Der,
(Name loaded to see the result better)
You can try this expression.
mid(Data,Index(Data,'(')+1,Index(Data,')')-Index(Data,'(')-1) as New_Data
Retrieving data ...