So I have a file containing data of a marathon. Here's an example what it looks like including the given key:
My task is to extract all lines that feature a runner's last name starting with a C.
What I did was; I sorted the file according to key 4 and redirected the output to a new file, which gave me the list sorted in alphabetical order according to their last name. I used this command to do this;
.
Does anyone know if there is a command that allows me to grep all entries which have the last name starting with C from the key position these terms are in?
Any help would be much appreciated.
I have tried to grep from a key position but the option I used(from sort) does not exist for grep;
Thank you
Last edited by Scrutinizer; 05-21-2018 at 08:59 AM..
Reason: code tags
---------- Post updated at 12:16 PM ---------- Previous update was at 12:12 PM ----------
Heyyy it worked, thank you so much
---------- Post updated at 01:56 PM ---------- Previous update was at 12:16 PM ----------
Hey,
So I'm having issues sorting a data set.
The data set contains entries as such;
I now want to sort this file according to the name of the athlete's, however, I don't want to sort it alphabetically but according to the number of names the athletes have. So for instance, I would like to sort the entire document starting with the entries of all the athletes that have 2-word names, then all the athletes with 3-word names and so on. Is this possible using sort?
I have tried various commands;
But I haven't managed to sort the data in the way I want it.
Does anyone know what I'm doing wrong?
Thanks in advance for your help.
Try introducing an extra column 1, that contains the number of words in column 3, then sorting on that column and then removing the extra column, for example: NR>1 && NF skips the header and the empty line and split($3,F," ") produces the number of words in column 3
Last edited by Scrutinizer; 05-21-2018 at 05:08 PM..
This User Gave Thanks to Scrutinizer For This Post:
In file, we have millions of records each of 1000 in length. And at specific position say 800 there is a space, we need to replace it with Character X if the ID in that row starts with 123.
So far i have used the below which is replacing space at that position to X but its not checking for... (3 Replies)
Hi ,
I have a file where i have modifed certain things compared to original file . The difference of the original file and modified file is as follows.
# diff mir_lex.c.modified mir_lex.c.orig
3209c3209
< if(yy_current_buffer -> yy_is_our_buffer == 0) {
---
>... (5 Replies)
Hi
I'm new to the forum, so I'd apologize for any error in the format of the post.
I'm trying to find a file content in another one using:
grep -w -f file1 file2
file1
GJA7
TSC
file 2
GJC1 GJA7
TSC1 TSC (11 Replies)
I am trying to find/grep the 5th and 6th position character (TX) of a word in a file. I tried to do
grep "....TX" file
The output gives me everything in the file with TX in it. I only need the output with the TX in the 5th and 6th position of the word. Any idea
Example:
test1 car... (5 Replies)
I would need a command for finding first 15000 of the file names whose 25th postion is 5 in the current directory alone.
I do have this painful command
find . -name '5*' | head -15000 | cut -c3-
please refine this.
Of course the above command also searches in the sub directories... (3 Replies)
hello I'm doing a unix program and i'm using many file csv.in each csv file the colums are separated by ";" I would like to know the position of a pattern. For example for a line yyyy, bbbb, cccc; ddddd;eeee. I will like for example by finding the position of the pattern "cccc" and the response is... (6 Replies)
Assume I have a file with a lot of data sets like
123 abc 01
456 def 02
789 ghi
and I only want to grep all that datasets from my file having the pattern '02' at the postion 9-10 to get only
456 def 02
So I could group the datsets into three files according to the position 9-10, one... (9 Replies)
I have a set of .gz files. I need to grep a pattern and need to find out the file in which that pattern occurs. zgrep in not available in my server.Any other options available for searching a pattern without unzipping the .gz files. (2 Replies)
Dear friends
I am new to linux and was trying to split some files userwise in our linux server.
I have a data file of 156 continuous columns named ecscr final.
I want the script to redirect all the lines containing a pattern of 7 digits to separate files. I was using grep to do that,... (2 Replies)
Hi,
This was very unusual situation I never came across & we have SUN engineers working on this.
We have Sun Fire V240 Server, 2 1.5-GHz UltraSPARC IIIi CPU, Solaris 9 Installed
During the boot-up it gives following message,
<date> <server name> unix : KEY in LOCKED position ignoring... (5 Replies)