10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In the awk below I am trying to set/update the value of $14 in file2 in
bold, using the matching NM_ in $12 or $9 in file2
with the NM_ in $2 of file1.
The lengths of $9 and $12 can be variable but what is consistent is the start pattern
will always be NM_ and the end pattern is always ;... (2 Replies)
Discussion started by: cmccabe
2 Replies
2. Shell Programming and Scripting
In the out.txt below I am trying to use awk to update the contents of $9.. If $9 contains a + or - then $8 of out.txt is used as a key to lookup in $2 of file. When a match ( there will always be one) is found the $3 value of that file is used to update $9 of out.txt separated by a :. So the... (6 Replies)
Discussion started by: cmccabe
6 Replies
3. Shell Programming and Scripting
Trying to use awk to:
update $2 in file2 with the $2 value in file1, if $1 in file1 matches $13 in file2, which is tab-delimeted. The $2values may already be the same so in that case nothing happens and the next line is processed.
There are exactly 4,605 unique $13 values. Thank you :).
... (4 Replies)
Discussion started by: cmccabe
4 Replies
4. Shell Programming and Scripting
In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of
HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=.
Hopefully the awk is a start but I... (2 Replies)
Discussion started by: cmccabe
2 Replies
5. Shell Programming and Scripting
Look at this simple example.
echo " 2 4 6" | awk '{$2+=3;$3-=1}1'
2 7 5
Is there a simple way to update a field and at the same time keep the formatting?
I would like to get it like this
2 7 5
I have tested both sub and gsub, it reformat too. (2 Replies)
Discussion started by: Jotne
2 Replies
6. Shell Programming and Scripting
I am trying to add 0393 value at 24th feild using the below command, but its adding at all the lines including header and trailer
Input file:
ZHV|2657|D0217001|T|TXU|Z|PAN|20131112000552||||OPER|
754|52479|
492|489|SP40|1014570286334|20131111|20131201|14355334|CHAMELON... (1 Reply)
Discussion started by: Aditya_001
1 Replies
7. Shell Programming and Scripting
Hi
I have a job status csv file. I want to update the status of the job in the file.
Below is the csv file
1,jobname1,in_progress,starttime,somthing,somthing
2,jobname2,completed,starttime,somthing,somthing
3,jobname3,failed,starttime,somthing,somthing... (8 Replies)
Discussion started by: midhun19
8 Replies
8. Shell Programming and Scripting
I have a file contains 100 section (here i show 2 section of that); i want to replace date from 1st & 2nd field of 1st line of each section (1st line of each section is header and the other lines are body) and merg them into one field, then copy it on 7th field of the lines in each section... (17 Replies)
Discussion started by: oreka18
17 Replies
9. Shell Programming and Scripting
Hi All,
i have a file file.dat with following data :
CONTENT_STORAGE PERCENTAGE FLAG:
storage_02 64% 0
storage_01 17% 1
i need to update FLAG field of storage_02 to 1
i am using the following: but its not working :
awk '{FS=OFS=" "}$1==$defaultStorage1{$3="1"}1'... (13 Replies)
Discussion started by: kichu
13 Replies
10. UNIX for Dummies Questions & Answers
The auditors have nailed us for world writeable files....
Apparently in years gone by, quite a number of our kornshell scripts have had:
umask 000 put in the script.
We have been able to turn off world writeable for existing dirs & files, but as these scripts run, new files keep getting... (1 Reply)
Discussion started by: kornshellmaven
1 Replies