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...
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)
Hi,
Try this:
subfield((SubField(Name,'(',2)),')',1)
HTH
Sushil
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)
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