Have another thing that I'm trying to solve for 4th column if empty replace with "novalue" what is the best way to get this in awk
Moderator's Comments:
Start using code tags as you have been asked for, thanks.
Moderator's Comments:
Please start a new thread for a new problem. That way you don't confuse people like rdrtx1 who try to give yu a solution that matches the thread title when you have a new problem that does NOT match the thread title.
In addition to what RavinderSingh13 suggested, you could also try the slightly simpler:
Hey Everybody,
I am having much trouble figuring this out, as I am not really a programmer..:mad:
Datafile.txt
Column0 Column1 Column2
ABC DEF xxxGHI
I am running using WGET on a cronjob to grab a datafile, but I need to cut the first three characters from... (6 Replies)
BAQ001 /dev/rdsk/c2t0d7 1C13 (M) RW 69053
The line above is from a text file. I want to use awk to extract the value in the third column 1C13.
I just can't seem to get the syntax right or something. Any help would be appreciated.
Thanks, (5 Replies)
- I am looking for different kind of awk solution which I don't think is mentioned before in these forums.
Number of rows in the file are fixed
Their are two columns in file1.txt
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
I am looking for 3... (1 Reply)
Hi,
I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column.
clientname,day-of-month,max-users
-----------------------------------
client1,20120610,5
client2,20120610,2
client3,20120610,7... (3 Replies)
Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately.
Here's some example output:
Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop
bond0 9 83830... (3 Replies)
Hi, I have a file with +/- 13000 lines and 4 column. I need to search the 3rd column for a word that begins with "SAP-" and move/skip it to the next column (4th). Because the 3rd column need to stay empty.
Thanks in advance.:)
89653 36891 OTR-60 SAP-2
89653 36892 OTR-10 SAP-2... (2 Replies)