---------- Post updated at 01:13 PM ---------- Previous update was at 01:06 PM ----------
Quote:
Originally Posted by Unilearn
Hi getmmg,
Thanks for the code. It works fine. But after merging the 7th and 8th columns, it leaves the 8th, 10th, 12th etc. columns empty. For ex.
output:
1 mike 0 0 2 1 AA__GG__CT__AG
1 jack 0 0 2 2 TA__GT__CA__ AC
1 Mary 0 0 1 2 AT__GC __AT__GC
would it be possible to delete all these empty columns once and get the output like,
1 mike 0 0 2 1 AA GG CT AG
1 jack 0 0 2 2 TA GT CA AC
1 Mary 0 0 1 2 AT GC AT GC
That would be great!
Hi bartus11,
thanks for the code. But for some reason it is doing nothing. I get the empty output! any hints on that!
Thanks
Can you guys help me, I have two files:
File A
60|11111|
601|11111|
6012|11111|
6013|11111|
60142|11111|
File B
642|11111|
659|11111|
852|11111|
6012|11111|
6013|11111|
I want to combine the two file into:
File C
60|642|
601|642|
6012|642| (2 Replies)
Hi Guys,
I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated.
inputfile1.txt
12345
67890
24580
inputfile2.txt
AAAAA
BBBBB
CCCCC (11 Replies)
Hello everybody,
I have some large files containing statistical data. The data is stored in the following generic format:
>cat my_file
1, 2, 3
1, 2, 3
1, 2, 3
>
The values of columns no.2 and 3 are expressed in bytes. I would like to transform them in Megabytes, by dividing them with... (3 Replies)
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Hi, I am trying to multiply column#1 with column#2 using a shell script. How can I make a for-loop script using 1st column as "i" and the second column as "j" from the following file? Please feel free to share any alternative ways to multiplying column#1 with column#2.
.06 5.0000
.49 ... (6 Replies)
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Good morning all,
I have a problem that is one step beyond a standard awk compare.
I would like to compare three files which have several thousand records against a fourth file. All of them have a value in each row that is identical, and one value in each of those rows which may be duplicated... (1 Reply)
I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns:
id name parentID
4 D 2
2 B 1
3 C 1
1 A 5
I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this:
awk '{arr;}... (7 Replies)
Columns 4 and 5 are X and Y coordinates, column 6 is the elevation
I would like to add 2 new columns at the end of the file with values
the distance between first(X)(Y) and last location (X)(Y), based in 2 rows
the difference in elevation = ($6-prev6)
How to calculate the requested values... (6 Replies)