Extracting string between special characters

[#1]

Hi everyone,

I'm trying to split out a field into two new fields. This is the string pattern and I'm looking to put everything between the first set of single quotes into fieldA, and everything between the second set of quotes into FieldB. I've found this http://community.qlik.com/message/108212#108212 which I can adapt to single quotes but can't figure out how to make it work on the first then the last.

CALLTIME CHANGED FROM '71:11' TO '20:10'

Can anyone help out?

Many thanks.

P

[hectorgarcia]

hope you find itr helpfull

t:

load *,

TextBetween(F1,'TO '&chr(39),chr(39)) as Field2,

TextBetween(F1,chr(39),chr(39)&' ') as Field1;

LOAD * INLINE [

F1

"CALLTIME CHANGED FROM '71:11' TO '20:10'"

];