Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rajni_batra
Valued Contributor

Read Particular text from Unix Log

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

Tags (1)
5 Replies

Re: Read Particular text from Unix Log

Rajni,

Can you please show me the sample o/p

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

Life is so rich, and we need to respect to the life !!!

Re: Read Particular text from Unix Log

Please share few sample records with output needed?

ashishkalia
Contributor

Re: Read Particular text from Unix Log

Hi

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

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

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>

];


Capture.PNG

Community Browser