Hi ,

I have data in below pattern

05:00:13,184 WARN [15501-24] ContentTransferService - CTS:createContent - File Name:470208627 Total time taken(ms):5137
05:00:13,184 WARN [15501-23] ContentTransferService - CTS:createContentWithFolderPath(uploadDocument) - File Name:[COLOR="rgb(139, 0, 0)"]295918481 [/COLOR]User Id:xyz Total time taken:5804

I want the output like

470208627 -- 5137
295918481 -- 5804

Can you please help me with it ? I tried few grep and awk but couldn't get it .

perl -lne '(/File Name:(\d+).*?time taken.*?:(\d+)/ || /File Name:.*?\](\d+).*?time taken:(\d+)/) && print "$1 -- $2"' file

Thanks for the reply.

It works fine with the File Name as number but if the file name is alphanumberic then it doesnt work.These data get missing from the result.

File Name:DLFE-300818427.pptx Total time taken(ms):3785

Solution based on following assumption

• all int have const length and all lines are in data.dat

for ln in `cat data.dat`
do
fin=`grep [0-9]{8} $ln`
lin=`grep[0-9]{4} $ln`
echo $fin----------$lin
done

Hi ,

The command works fine
perl -lne '(/File Name\d+).*?time taken.*?\d+)/ || /File Name:.*?\](\d+).*?time taken\d+)/) && print "$1 -- $2"'

But if the name is alphanumberic (DLFE-192818716.pptx) it doesnt work . I tried with /w option but that terminates the filename .

perl -lne '(/File Name:([\w.-]+?) .*?time taken.*?:(\d+)/ || /File Name:.*?\]([\w.-]+?) .*?time taken:(\d+)/) && print "$1 -- $2"' file