I have a file that looks like this.
How can I replace each empty space with a TAB except in the last column that starts with ID?
chr1 13513 14763 Medtr1g004950 . + JCVI gene . ID=Medtr1g004950;Note=...
I have a file with several thousand lines describing the output from an elastic wave mode
code. The size of the file is variable depending on the frequency, the thickness of the
model, and the number ...
I have a data like this:
and for each value of $1, I want to get the median value of all the values of $2 for that $1 if possible using AWK ...
I would like to compare one column from one file against another column in another file. If the columns match, I would like to append the first column from the first file, as the first column of the ...
I have an awk script named text_processing.awk . I need to pass multiple zipped files named 01JAN21.txt.gz , 02JAN21.txt.gz etc. to this script for further processing. The output file takes the date ...
I have a text file looking like this
username:some alphanumeric string
password:some alphanumeric string
And a yaml file looking like this
Edit: edited it for clarity and made the example files minimal and more reproducible for easier help. Thanks!
I have files that gave 1000+lines. Each file is formatted with the same amount of lines. ...
How to group docker stats --no-stream by container prefix, and show the sum of RAM and CPU and network and IO?
If we consider the first two columns of the docker stats --no-stream command to be like ...
I am creating an output file inside an awk script which I want to compress then.
Input file - Marks.txt
I have a list of data, like a CSV but some lines are missing a value. I'd like to generate a value for the missing line based on the lines before and after using linux shell script.
Take this table ...
I would like to ask, how can I join multiple files into one using a specific column and name it by the originating folder.
Let me explain: I have the following files, having multiple columns and rows:
While writing some awk code I was using the --lint option for gawk 4.1.0.
To my surprise I get a warning
warning: range of the form `[o-b]' is locale dependent
but my code has only a foo-bar outside ...
I am trying to change the date format in file with the full year. This is my data.
06/30/21 07/01/21 05436841182400056721972 random text
07/06/21 07/07/21 05436841188400057034635 random text
I need to select the rows containing a certain character in the 1st column and having the digits in the 1st column greater than a specific value.
Specifically, I need to select the rows containing a '...
An example of the data is as follows. The first two columns are IDs and the third column is the frequency.
1 2 99
2 3 62
4 5 80
4 4 98
5 5 79
6 1 98
The first and second columns are the same person ...
I have 12 text files all in one folder, each with about 5 million lines, each file has no duplicate line on its own but there are duplicated across multiple files, I want to remove the duplicate lines ...
There are multiple related Questions, seems they don't use awk to solve the problem.
Extracting positive/negative floating-point numbers from a string
How to extract the numbers from a filename
I need to compare two txt files containing several lines and create a third txt file with only lines that are unique to file 1.
An example of file 1 is the following:
../../A/folder/fname.gz | -12.36 |...
In a file that has any garbled text before and after a section that is marked by patterns START and END (specific strings that occur only once each and in the correct order and on the same line). I ...
i have a big csv file (5gb) with 300 columns, and i want to add a simple header via the commande line :
row-0;row1;row2 ... row299
i used sed (without a loop) :
sed -i 1i'row-0;row-1;row-2 .... ; row-...