I feel like a real leech now, 3 questions in 3 days, but hopefully when I get my head around all of this I can contribute back to this community!
Anyway, so a couple of you guys have gotten me onto AWK and I've been researching it a little over the last couple of hours, now I'm somewhat sure I know the answer to this question, I'm just chasing confirmation.
In AWK $0 will grab an entire line (record) $1 will grab the first field, $2 grabs the second etc
I'm curious as to what exactly constitutes a field.
Personally I think a field is just 1 character, but part of me thinks that it would be 1 string.
With the following data for example:
Quote:
700k ../acushare.err
Now, printing $0 should print that entire line
What does printing $1 output? 7? or 700k?
Mid way through creating this thread I attempted to test this theory myself, but i couldn't quite use the right command apparrently.
I tried the following:
1.
output: blank line
2.
output: empty file
3.
output: empty file
I also tried print by itself with no luck.
Which I guess means I'm asking a new sub-question here, why is my command not working?
So.. long and short of it, an hour or so research and I'm still complete and utter noob!
Any and all help as always is greatly appreciated
Last edited by Aussiemick; 06-09-2011 at 09:48 PM..
Reason: extra info
Just written a great little script that analyses a flat ASCII CSV file and reports for any discrepancies with field counts per record etc.
Works fine on all the flat files except one, which has 113 fields per line. AWK can only seemingly cope with up to 99 fields.
Is there any way around... (2 Replies)
I am using:
ps -A -o command,%cpu
to get process and cpu usage figures. I want to use awk to split up the columns it returns. If I use:
awk '{print "Process: "$1"\nCPU Usage: "$NF"\n"}'
the $NF will get me the value in the last column, but if there is more than one word in the... (2 Replies)
#cat BATCH007.TXT
01,661060052,061000104,081118,0915,07,80,1,2/
99,,,2/
I have this file called BATCH007.TXT. I am trying to change fields 2 and 3 on line 2 to have zeroes. Like this:
01,661060052,061000104,081118,0915,07,80,1,2/
99,0,0,2/
I can use these commands to print identify the... (2 Replies)
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Hi there, i need some help please...
I have this text, it's name data.txt that contains the following information:
Mark Owen: 6999999888 6999999888 +302310999999 2310999999
Steve Blade Pit: +30691111222 2310888777 6999999888
John Rose: 2310777555 310544565 +302310999999
Mary Stuart:... (7 Replies)
Hi,
Could someone please let me know me how i can use an awk command to print the No. of fields of each file present in a Directory?Suppose the Directory has 5 text files in which the first record in each file contains fields separated by a '|'. I need to use a awk command to display the No... (8 Replies)
Hi All,
I am looking for an awk script to do the following
Join the fields together only if the first 4 fields are same.
Can it be done with join function in awk??
a,b,c,d,8,,,
a,b,c,d,,7,,
a,b,c,d,,,9,
a,b,p,e,8,,,
a.b,p,e,,9,,
a,b,p,z,,,,9
a,b,p,z,,8,,
desired output:
... (1 Reply)
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of... (7 Replies)
Hi
I have a file as below
<field1> <field2> <field3> ... <field_num1> <field_num2>
Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields.
I tried this and it doesn't sort on the difference field .. Appreciate your help.
cat... (9 Replies)