Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Rajni,
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?
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....
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
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>
];