I have files and have a missing record. I need copy the existing record and mark those values up. For example in the below file 11048 is missing. I need to copy 22001 and copy those create the values for 11048 . I have 120 set of files and I need to do that on all files.
Note the only ID I am missing is 11048 and I have to copy the 22001 to it. There are 120 files I have to do which will be on name file1,file2 ----file120
If you have latest version of awk OR gawk which allows us to save output into Input_file(s) itself then following may help you on same(since I don't have the latest version so I couldn't test it).
Solution 1st: If you want to save the output into Input_file(s) itself then following may help you.
Solution 2nd: If you want to save the output into Input_file(s) along with taking the backup of original Input_file(s) too then following may help you on same.
How do you know it's 11048 that is missing? And how do you know 22001 should be used to fill in the gap?
If those are constants, and no logics / algorithms needed / applied, it might be easier to just use an editor and do a block copy.
Both gawk didn't worked. I got the below error. I think I am using old version of awk, Below is what I tried my input files in format like LATAM_TRANS so I replace the input file in the command
gawk -i inplace -v -F";" 'FNR==1{close(file);file=FILENAME} /22001/{val=val?val ORS $0:$0;$1=11048;val_11048=val_11048?val_11048 ORS $0:$0;next} /22002/ && val && val_11048{print val_11048 ORS val;val=val_11048="";next} 1' OFS=";" LATAM_TRANS
Usage: gawk [POSIX or GNU style options] -f progfile [--] file ...
Usage: gawk [POSIX or GNU style options] [--] 'program' file ...
POSIX options: GNU long options:
-f progfile --file=progfile
-F fs --field-separator=fs
-v var=val --assign=var=val
-m[fr] val
-W compat --compat
-W copyleft --copyleft
-W copyright --copyright
-W dump-variables[=file] --dump-variables[=file]
-W exec=file --exec=file
-W gen-po --gen-po
-W help --help
-W lint[=fatal] --lint[=fatal]
-W lint-old --lint-old
-W non-decimal-data --non-decimal-data
-W profile[=file] --profile[=file]
-W posix --posix
-W re-interval --re-interval
-W source=program-text --source=program-text
-W traditional --traditional
-W usage --usage
-W version --version
To report bugs, see node `Bugs' in `gawk.info', which is
section `Reporting Problems and Bugs' in the printed version.
gawk is a pattern scanning and processing language.
By default it reads standard input and writes standard output.
Examples:
gawk '{ sum += $1 }; END { print sum }' file
gawk -F: '{ print $1 }' /etc/passwd
Yes the values are constant. I am using VI to do that. I have to do on 120 files on a directory. Like that I am having 18 directories. I have to find where 22001 is in the file and the copy it and then place it above as 11048. So it is taking time. Worked for 7 hours I completed only 96 files where I have 18*120 files
It worked. But it replaced the order. If you look below the second position is the order it is like 1,2,3,4. After doing the replace in command it replaced the order