I have a file which has patterns of repeated lines. The pattern should be:
a = name
b = var1
c = var2
d = var3
Sometimes though one of these lines (or more) is missing (2nd c line below):
a = name1
b = 100
c = 33
d = 800
a = name2
b = 100
d = 800
a = name3
b = 100
c = 33
d = 800
When this happens I want to inject a default value (say 35) for that missing variable.
I dont necessarily need it to be inserted into the file as it is displayed above because the next step is to produce a file that looks like:
name1 800 100 33
name2 800 100 35
name3 800 100 33
Note above that 35 was inserted to maintain consistancy (and has meaning). So this value could be inserted as the values are put into the column format. This would then allow me to sort the file based on column 2 first, then 3, then 4:
name1 800 100 33
name3 800 100 33
name2 800 100 35
Then using uniq -d I could display any duplicates so the end result would be the script alerting me to duplicate lines (not including checking the name for dups as these will be always be unique):
#script output:
namex 100 33 800
Not sure which dup line would be displayed, but the important thing would be that one of the two dup lines was displayed.
I have some commands to do the last couple parts
# sort based on column2, then column3, then column4
sort +1 -2 +2 -3 +3 -4
# display any duplicates lines not including column 1
uniq -d -1
What I'm struggling with is setting an expected pattern of lines, and then inserting a value when part of the pattern is missing. Any help that could be provided is appreciated.
