Filter from filed.

[sona_sa]

Hi,

I have a field. In the same filed date are like that :

CONSULTANCY - AFFILIATES (AFF002)

DT GROUP NAV-PROD (708.8677)

AUSTRALIA - NAV (PRJ001)

I Need only which are enclosed in braces. For Example :

CONSULTANCY - AFFILIATES (AFF002) = AFF002

DT GROUP NAV-PROD (708.8677) = 708.8677

AUSTRALIA - NAV (PRJ001) = PRJ001

Can anyone help me on the same.

Thanks.

[MayilVahanan]

Hi

Try like this

TextBetween(FieldName, '(',')')

TextBetween(' CONSULTANCY - AFFILIATES (AFF002)','(',')')

[#3]

Use TextBetween(FieldName,'(',')')

Regards,

KKR

[arulsettu]

try this too

=PurgeChar(SubField('CONSULTANCY - AFFILIATES (AFF002)','(',2),'()')

[qlikviewwizard]

Hi , MayilVahanan and arulsettu answers are working fine.

Filter_Data:

LOAD *, TextBetween(FIELD, '(',')') as TextBetween_FIELD,

PurgeChar(SubField(FIELD,'(',2),'()') as PurgeChar_FIELD;

LOAD * INLINE [

FIELD

CONSULTANCY - AFFILIATES (AFF002)

DT GROUP NAV-PROD (708.8677)

AUSTRALIA - NAV (PRJ001)

];

[#6]

Hi,

Please find the attached QVW.