Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: combine the values from the first two columns within a file
Top Forums UNIX for Dummies Questions & Answers combine the values from the first two columns within a file Post 302531153 by Unilearn on Thursday 16th of June 2011 03:36:08 AM
Old 06-16-2011
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:
Code:
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,
Code:
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
Last edited by Franklin52; 06-16-2011 at 04:48 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

combine two values within a file

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)
Discussion started by: lurak
2 Replies

2. Shell Programming and Scripting

How to combine 2 files into 1 file with 2 columns

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)
Discussion started by: pinpe
11 Replies

3. Shell Programming and Scripting

Math operations with file columns values.

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)
Discussion started by: fabian23
3 Replies

4. UNIX for Dummies Questions & Answers

Subtracting values from 2 columns in a file

Hello, I have a file with 5 columns that looks like this: A1BG chr19 + 58863335 58866549 A1BG chr19 - 58858171 58864865 A2LD1 chr13 - 101182417 101186056 A2LD1 chr13 - 101182417 101241046 A2M chr12 - 9220303 9268558 A2ML1 ... (5 Replies)
Discussion started by: wolf_blue
5 Replies

5. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

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)
Discussion started by: evelibertine
3 Replies

6. Shell Programming and Scripting

Help needed with multiplying two values of two columns in a file

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)
Discussion started by: momin
6 Replies

7. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

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)
Discussion started by: isildur1234
5 Replies

8. Shell Programming and Scripting

Compare multiple files, identify common records and combine unique values into one file

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)
Discussion started by: nashton
1 Replies

9. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

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)
Discussion started by: kaktus
7 Replies

10. UNIX for Beginners Questions & Answers

Add values to file in 2 new columns

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)
Discussion started by: jiam912
6 Replies

LEARN ABOUT DEBIAN

xjack

xjack(6x)							XScreenSaver manual							 xjack(6x)

NAME

       xjack - all work and no play makes jack a dull boy

SYNOPSIS

       xjack [-display host:display.screen] [-foreground color] [-background color] [-window] [-root] [-delay usecs] [-fps]

DESCRIPTION

       All  work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All
       work and no play makes jack a dull boy.	All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

	       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes  jack  a  dull
	       boy.   All  work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a
	       dull boy.

	       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes  jack  a  dull
	       boy.   All  work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a
	       dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.   All
       work and no play makes jack a dull boy.	All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work
       and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

ENVIRONMENT

       DISPLAY All work and no play makes jack a dull boy.

       XENVIRONMENT
	       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

SEE ALSO

       X(1), xscreensaver(1)

COPYRIGHT

       Copyright (C) 1997 by Jamie Zawinski.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.	 All  work
       and  no	play  makes  jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a fnord dull boy.  All
       work and no play makes jack a dull boy.

AUTHOR

       Jamie Zawinski <jwz@jwz.org>, 15-Nov-97.

X Version 11							5.15 (28-Sep-2011)							 xjack(6x)
All times are GMT -4. The time now is 09:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy