topic Re: String in QlikView

String

Tue, 12 May 2015 07:32:32 GMT

Hi All,

I have a string as ABC DEF MMMM YYYY GHI JKL MNO.xls.

I wish to separate the MMMM YYYY field from the name.

Is it possible?

Thanks,

Asma

Re: String

Anonymous — Tue, 12 May 2015 07:37:42 GMT

mid ( 'ABC DEF MMMM YYYY GHI JKL MNO.xls.' , 9 , 9 )

Re: String

Ralf-Narfeldt — Tue, 12 May 2015 08:54:17 GMT

Is it just this specific string, or do you need to apply it to other strings following a pattern?

Is MMMM YYYY month/year information?

Re: String

anbu1984 — Tue, 12 May 2015 09:07:00 GMT

Load FlNmWrd & ' ' & TextBetween(FlNm,FlNmWrd & ' ',' ') Where Wildmatch('January|February|..|December','*'&FlNmWrd&'*');
Load FlNm,SubField(FlNm,' ') As FlNmWrd;
Load * Inline [
FlNm
ABC DEF December 2015 GHI JKL MNO.xls ];