I am new to cut and I want to use the field option with a space delimiter on an Apache log file.
For example, if I wanted to find the 200 HTTP code using cut in this manner on the file below
As I look at the file and count the spaces since that is the delimiter I am using I don't get it being f7. I get f8. I'll use the smileys to signify a space.
There may be an easier way or better way to do this but what I am wanting to know is how to count the fields. As it is now, I can do trial and error and find the field but I want to know the correct way to count them because above it shows 8 spaces and that seems to me to be f8 but the command is f7 that works.
Thanks,
Moderator's Comments:
Do NOT use smileys mixed with spaces to show spaces; it confuses everyone trying to figure out what your input looks like. Just use CODE tags. And, use CODE tags for ALL sample input, sample output, and code segments.
Last edited by Don Cragun; 06-08-2015 at 11:31 PM..
Reason: Add ICODE and CODE tags; add note.
Is there a way to count the no. of fields (columns) in a file?
Actually I need to cut some fields starting from the middle to the end. How can I specify to cut till last field?
thanks in advance
:) (4 Replies)
I want to cut two coloums simulatiously and paste in some other file
for ex:
cut d ' ' -f3 -f4 xxx | paste yyy - > zzz;
from the above i want to cut two fileds 3 and 4 and paste as last coloums of single file (zzz).
how to solve this
regards
rajan (1 Reply)
I have a tab delimited file which has 90 fields and 15 million rows approximately...
I need to cut the first 78 fields only and I am using the
cut -f1-78 <filename> <outputfile>
It is taking a lot of time...
Is there a faster way of doing this? Can we use NAWK to gain better... (0 Replies)
I have a text:
dsj khfksjdh <time> EST 2006
ab cgnr jkkjt <time> EST 2006
gfhdgjghg <time> EST 2006
fkdjh kjhsekjrh kdjhfkh jhdfkhfdkjh kjdf <time> EST 2006
In the above file i need to extract time from every line... which is always the third from the last... Pls help!
Cheers,
Bouren (4 Replies)
Hello,
I would like to extract one or two fields of a line.
At the moment, I am extracting the first field of a line:
command | cut -f 1 -d '.' > file
The line can have two or three fields delimited with a dot.
if three fields, I want to be able to get the first two
ie if line =... (3 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,
I have data in following format.
10001, John, Daves, Architecture, -2219
10002, Jim, Cirners, Businessman, -2219
1003, Tom, Katch, Engineer, -14003
I want to select the last column of the above given file and paste it on a different file in the following manner.
File TEST column... (11 Replies)
Hello All,
I got a requirement when I was working with a file. Say the file has unloads of data from a table in the form
1|121|asda|434|thesi|2012|05|24|
1|343|unit|09|best|2012|11|5|
I was put into a scenario where I need the field count in all the lines in that file. It was simply... (6 Replies)
I'm having bother getting both lines contained in a file to output as the same value.
A simple example:
john:123456:123:456:doe
john:123456:123:doe
cut -d: -f1,4 input file
john:456
john:doe ^ first line should be same as second.
trick one for me, i know why it's because of the... (4 Replies)
I'm a complete beginner in UNIX (and not a computer science student either), just undergoing a tutoring course. Trying to replicate the instructions on my own I directed output of the ls listing command (lists all files of my home directory ) to My_dir.tsv file (see the screenshot) to make use of... (9 Replies)