Shell Programming and Scripting

Hi,

Instead of displaying the entire content from both the files like this

==========================================
Table Name: AQ$_FT_Q_BECMD_H
Row Count: 0 SUM(SUBSCRIBER#):MAX(SUBSCRIBER#): MIN(SUBSCRIBER#): AVG(SUBSCRIBER#):LENGTH(NAME):SUM(ADDRESS#): MAX(ADDRESS#):MIN(ADDRESS#):AVG(ADDRESS#): LENGTH(TRANSACTION_ID): SUM(DEQUEUE_USER): MAX(DEQUEUE_USER):

Table Name: AQ$_FT_Q_BECMD_H
Row Count: 1 SUM(SUBSCRIBER#): 11 MAX(SUBSCRIBER#): 11 MIN(SUBSCRIBER#): 11 AVG(SUBSCRIBER#): 11 LENGTH(NAME) 24 :SUM(ADDRESS#): MAX(ADDRESS#): 0 MIN(ADDRESS#): 0 AVG(ADDRESS#): 0 LENGTH(TRANSACTION_ID): 4 SUM(DEQUEUE_USER): 0 MAX(DEQUEUE_USER): 0 LENGTH(DEQUEUE_USER): 50

==========================================

Can it be displayed this way?

SUM(SUBSCRIBER#) from the table AQ$_FT_Q_BECMD_H has mismatches in both the files
SUM(SUBSCRIBER#): 11
SUM(SUBSCRIBER#):

MAX(SUBSCRIBER#) from the table AQ$_FT_Q_BECMD_H has mismatches in both the files
MAX(SUBSCRIBER#): 11
MAX(SUBSCRIBER#):

in addition to this if a particular field is present in one and not in the other file then can the output be added

LENGTH(DEQUEUE_USER): 50 from the table AQ$_FT_Q_BECMD_H is present in file two and not in file 1.

Can you help? and is there a way to ignore the spacing difference?

Hi,

Can anyone please help me? Its really urgent.

Hi,

The spacing in the input files which i have received is not uniform. There are spacing differences in both the files.So the output was not correct.How can this script be modified to ignore spacing difference? Please help.I should deliver it in another six hours.

nawk '
/^Table Name/ { table = $3 ; tables[table]++ }
! NF || /^-+/ { next }
NR == FNR { stats1[table] = stats1[table] $0 ORS ; next }
{stats2[table] = stats2[table] $0 ORS ; next }
END {
for (t in tables) {
if (stats1[t] != stats2[t]) {
out = "-----------------------------------------------------------------" ORS
out = out stats1[t] ORS stats2[t]
print out
}
}
}
' $e $f >> result.out

The content of the input files which i have received

File 1

Table Name: AAA
Row Count: 96 ~~SUM(F1): 3739 ~~MAX(F1): 77 ~~MIN(F1):0 ~~AVG(F1): 38.94791666666666666666666666667 ~~LENGTH(LINE): 2260


File 2

Table Name: AAA
Row Count: 96 ~~SUM(F1): 3739 ~~MAX(F1): 77 ~~MIN(F1): 0 ~~AVG(F1): 38.94791666666666666666666666667 ~~LENGTH(LINE):2260

Please help.

It's not at all clear where there are spacing differences. Can you point out what works and what doesn't?

There are spaces between the fields. For example considering this
SUM(F1): 3739. There could be spacing between these two words. But the spacing difference is not constant in both the files.And the spacing is not constant between the field and the field value.Can you help me in bringing the output into a particular single format in both the files ignoring the spacing differences and compare and only print exactly the mismatches?I am not able to show the spacing differences here.

With code tags you can.

How about simply run the text through tr -s " "?

Hi,

I have attached both the files.I have also attached the code which i have used.Kindly help me.file1.txt

file2.txt

code.txt