Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
mid ( 'ABC DEF MMMM YYYY GHI JKL MNO.xls.' , 9 , 9 )
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?
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 ];