Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
It's not working...
Hi,
Try this:
LOAD
subfield(subfield(Name,'(',2),')',1) as Name_Der
FROM Data.xlsx (ooxml, embedded labels, table is Sheet1);
This will work.