CODEWITHSUNDEEP
bashsedawk
Allen
Allen

Reputation: 51

Extracting text from file using bash

I am new to Linux and have a very large text log file from which to extract. I thought to use bash?

For example, the file contains:

Node:xyz
Time:01/07/13 14:26:17
INFO: Trusted certif ok

Node:abc
Time:01/07/13 14:26:18
INFO: Trusted certif ok

Node:def
Time:01/07/13 14:26:18
INFO: Trusted certif not ok

I need to extract the text after Node: and add it to the text after Info: to display on one line, output to be redirected to a new file. I am trying awk and sed, but not figured it out yet. Help much appreciated.

Example output would look like:

xyz Trusted certif ok
abc Trusted certif ok
dbf Trusted certif not ok

Upvotes: 4

Views: 17607

Answers (4)

Sidharth C. Nadhan
Sidharth C. Nadhan

Reputation: 2253

sed -n 'N;N;s/\n.*\n/ /;s/\S*://g;p;n' file

Upvotes: 0

Gilles Quénot
Gilles Quénot

Reputation: 185881

Try doing this :

in 

awk -F: '/^Node/{v=$2}/^INFO/{print v $2}' file.txt

in :

while IFS=: read -r c1 c2; do
    [[ $c1 == Node ]] && var=$c1
    [[ $c1 == INFO ]] && echo "$var$c2"
done < file.txt

in :

perl -F: -lane '
    $v = $F[1] if $F[0] eq "Node";
    print $v, $F[1] if $F[0] eq "INFO"
' file.txt

in (in a file, Usage : ./script.py file.txt ): 

import sys
file = open(sys.argv[1])
while 1:
    line = file.readline()
    tpl = line.split(":")
    if tpl[0] == "Node":
        var = tpl[0]
    if tpl[0] == "INFO":
        print var, tpl[1]
    if not line:
        break

Upvotes: 13

Vijay
Vijay

Reputation: 67319

perl -F: -lane '$x=$F[1] if(/^Node:/);if(/^INFO:/){print "$x".$F[1];}' your_file

tested below:

> cat temp
Node:xyz
Time:01/07/13 14:26:17
INFO: Trusted certif ok

Node:abc
Time:01/07/13 14:26:18
INFO: Trusted certif ok

Node:def
Time:01/07/13 14:26:18
INFO: Trusted certif not ok

> perl -F: -lane '$x=$F[1] if(/^Node:/);if(/^INFO:/){print "$x".$F[1];}' temp
xyz  Trusted certif ok
abc  Trusted certif ok
def  Trusted certif not ok

Upvotes: 0

perreal
perreal

Reputation: 98118

Using sed:

sed -n '/^Node/N;/Time/N;s/^Node:\([^\n]*\)\n[^\n]*\n[^ ]* /\1 /p' input

Upvotes: 2

Related Questions