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...
It's not working...
subfield(subfield(Name,'(',2),')',1) as Name_Der
This will work.
Retrieving data ...