Read Particular text from Unix Log

[rajni_batra]

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

[Anil_Babu_Samineni]

Rajni,

Can you please show me the sample o/p

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

[Kushal_Chawda]

Please share few sample records with output needed?

[ashishkalia]

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....

[marcus_sommer]

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

[tamilarasu]

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>

];