Extracting string between special characters

Mon, 08 Apr 2013 12:05:53 GMT

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.

Re: Extracting string between special characters

hectorgarcia — Fri, 09 Dec 2016 01:29:42 GMT

hope you find itr helpfull

load *,

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

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

LOAD * INLINE [

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

];

topic Extracting string between special characters in QlikView

Extracting string between special characters

Re: Extracting string between special characters