topic Re: Read Particular text from Unix Log in QlikView

Read Particular text from Unix Log

rajni_batra — Mon, 23 May 2016 06:47:05 GMT

Hi All,

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

[

Log

<rajnibat@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ12345<.....@rediff.com>

<abc@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ14567<.....@rediff.com>

];

Please Help here!!!

Thanks,

Rajni

Re: Read Particular text from Unix Log

Anil_Babu_Samineni — Mon, 23 May 2016 07:02:26 GMT

Rajni,

Can you please show me the sample o/p

If possible try to use wildmatch and then try ...

Re: Read Particular text from Unix Log

Kushal_Chawda — Mon, 23 May 2016 07:06:33 GMT

Please share few sample records with output needed?

Re: Read Particular text from Unix Log

ashishkalia — Mon, 23 May 2016 07:15:49 GMT

Just paste the below logic

=Subfield(subfield('<rajnibat@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ12345<.....@rediff.com>','>',3),'<',1)

highlight in bold is your string, if it is in any field then put your field name here and your done.

cheers....

Re: Read Particular text from Unix Log

marcus_sommer — Mon, 23 May 2016 07:16:49 GMT

Maybe something like this:

LOAD Log, 'RAJ' & TextBetween(Log,'>RAJ','<') as [Booking ID] Inline

[

Log

<rajnibat@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ12345<.....@rediff.com>

<abc@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ14567<.....@rediff.com>

];

- Marcus

Re: Read Particular text from Unix Log

tamilarasu — Mon, 23 May 2016 07:39:19 GMT

Hi Rajni,

Try this,

LOAD Log, Textbetween( Subfield(Log,'Timestamp<',2), '>','<') as [Booking ID] Inline

[

Log

<rajnibat@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ12345<.....@rediff.com>

<abc@gmail.com>Unix Timestamp<XYZ@yahoo.com>RAJ14567<.....@rediff.com>

];