CODEWITHSUNDEEP
bashawksed
ADAPA NIKHIL
ADAPA NIKHIL

Reputation: 57

Comparing the data from one file to another and print the output

I have three files of name - File1, File2 and File3. The data of the three files is shown below:

File1:

    // Class of "A2" of type "ONE".
    // Class of "A3" of type "ONE".
    // Class of "D1" of type "TWO".
    // Class of "D2" of type "TWO".
    // Class of "D3" of type "FOUR".
    // Class of "D6" of type "FIVE."

File2:

@CLASS_NAMES = ("one",
    "two",
    "three",);
@CLASS_LIST_NAMES = ("ONE.A1",
    "ONE.A2",
    "ONE.A3",
    "TWO.D1",
    "TWO.D2");

File3:

D3
D4
D5

I need to check in File1 Class "D3" is present in the File2 of @CLASS_LIST_NAMES or not. If it is not present in File2 of @CLASS_LIST_NAMES then I need to check in File3 if D3 is present there or not. If D3 is present in File3 then the output should be as PASS and if it not present in both File2 and File3 the output should be FAIL.

Similarly I need to check for all the Class list-(A2, A3, D1, D2....) from File1 if they are present in the File2 of @CLASS_LIST_NAMES or not and if they are not present in File2, I need to verify with File3 and print the output as PASS or FAIL.

I tried the below code:

#!/bin/bash

sed -n '/@CLASS_LIST_NAMES =/,/)/p' File2

I'm stuck at here, can anyone tell me what need to be done next.

Deisred_Output: As from File1 - D6 is not found in both File2 and File3 it should print as FAIL. The output should be like below:

Fail: D6 is not found

Upvotes: 1

Views: 97

Answers (1)

BarathVutukuri
BarathVutukuri

Reputation: 1303

You can achieve this with grep and awk

Use GNU grep which supports -P option

awk 'NR==FNR{a[$0]; next} !($0 in a){print "Fail: "$0 " is not found"}' <(cat file3 <(grep -Po '(?<=\.)[^"]+' file2)) <(grep -Po '(?<=of ")\w+' file1)

If you want to extract the classnames present only in the @CLASS_LIST_NAMES statement use below one.

awk 'NR==FNR{a[$0]; next} !($0 in a){print "Fail: "$0 " is not found"}' <(cat file3 <(sed -n '/@CLASS_LIST_NAMES/,/;$/p' | grep -Po '(?<=\.)[^"]+' file2)) <(grep -Po '(?<=of ")\w+' file1)

If the no of spaces in the file1 are not consistent, you can process using awk

# expects the 4th column is the variable, input format shouldn't change

awk 'NR==FNR{a[$0]; next} {gsub("\"","",$4)} !($4 in a){print "Fail: "$4" is not found"}' <(cat file3 <(sed -n '/@CLASS_LIST_NAMES/,/;$/p' | grep -Po '(?<=\.)[^"]+' file2)) file1

# alternate way using FPAT if the position of actual field can change, but it occurs first between double quotes

awk 'NR==FNR{a[$0]; next} {gsub("\"","",$1)} !($1 in a){print "Fail: "$1" is not found"}' <(cat file3 <(sed -n '/@CLASS_LIST_NAMES/,/;$/p' | grep -Po '(?<=\.)[^"]+' file2)) FPAT="\"[^ \"]+" file1

Upvotes: 4

Related Questions