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

[sushil353]

Hi,

Try this:

subfield((SubField(Name,'(',2)),')',1)

HTH

Sushil

[#3 · Accepted solution]

try :

//-----------

Temptabel:

LOAD  Textbetween(Name,'(',')') as Name_Der,

            Name 

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

//-----------

(Name loaded to see the result better)

[kaushiknsolanki]

Hi,

     You can try this expression.

     Load *,

      mid(Data,Index(Data,'(')+1,Index(Data,')')-Index(Data,'(')-1) as New_Data

     From xyz;

Regards,

Kaushik Solanki