String

[#1]

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

[Anonymous]

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

[Ralf-Narfeldt]

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]

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