Search Results

Thanks, but it doesn't meet my all requirements.

Because, if input file is:-

1: ### CREATE TABLE ##
2: SOMETHING ELSE 1 CREATE
3: ### CREATE TABLE ##
4: ### CREATE <spaces>
5: TABLE...

Hi,

Below are input files:-

File1:-

1: ### CREATE TABLE ##
2: SOMETHING ELSE 1
3: ### CREATE TABLE ##
4: ### CREATE <spaces>
5: TABLE ###
6:SOMETHING ELSE 2
7: ## CREATE
8:...

I have finally done that with a minor change:-

nawk 'BEGIN{ FS="|";c=0;d=0} NR==FNR{f1[$2]=$5;c++;next} NR==FNR+c {f2[$2]=$0;d++} NR==FNR+c+d{ print $4 in f1?$4 ( f1[$4] in f2?" ok ":" miss2...

thanks cherry. that works perfectly.

but, if you could just also tell me why this awk code is showing wrong message, that will help me further.

nawk 'BEGIN{ FS="|";c=0;d=0}...

I have three files and I have to do something like this:-

File A
1232|||1111 0001|||
1232|||2222 0001|||
1232|||4444 0001|||
1232|||4444 0001|||

File B
1232|1111 0001|||002222||
1232|2222...