Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

String

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

3 Replies

Re: String

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

Employee
Employee

Re: String

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?

anbu1984
Honored Contributor III

Re: String

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 ]
;

Community Browser