Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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

Ralf-Narfeldt
Employee
Employee

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
Master III
Master III

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