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

[#1]

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...

[#2]

It's not working...

[#3]

Hi,

Try this:

LOAD

subfield(subfield(Name,'(',2),')',1) as Name_Der

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

This will work.