Discussion Board for collaboration related to QlikView App Development.
I have a log from which i need to extract Booking ID (Identification is 8-20 character string starting with RAJ is my booking ID)
highlighed as BOLD below .
But the problem is email ID also starts with RAJ and i am getting wrog output. started many ways.
and many other cases i have.
LOAD Log, Replace(Log,TextBetween(Log,'<','>'),'*') Inline
Please Help here!!!
Can you please show me the sample o/p
If possible try to use wildmatch and then try ...
Please share few sample records with output needed?
Just paste the below logic
highlight in bold is your string, if it is in any field then put your field name here and your done.
Maybe something like this:
LOAD Log, 'RAJ' & TextBetween(Log,'>RAJ','<') as [Booking ID] Inline
LOAD Log, Textbetween( Subfield(Log,'Timestamp<',2), '>','<') as [Booking ID] Inline