Concatenate two columns and separate by - (minus)


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Concatenate two columns and separate by - (minus)
# 1  
Old 11-05-2012
Concatenate two columns and separate by - (minus)

hi all
could you please help me to concatenate two colomns and separate them by "-"
the two colomns to concatenate are colomuns 1 and 3 of a very bif file
clomn 1 is chr, 2 is snp and 3 is bp
the new colomn is chr_B

input file :
Code:
1    rs1111    10583
1    rs1891    10611
1    rs1807    13302

output:

Code:
1    rs1111    10583  1-10583
1    rs1891    10611   1-10611
1    rs1807    13302   1-13302

thanks
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!

Last edited by vgersh99; 11-05-2012 at 10:25 AM.. Reason: code tags, please!
# 2  
Old 11-05-2012
Code:
awk ' { print $0 $1 "-" $NF } ' input_file

# 3  
Old 11-05-2012
Code:
awk '{$NF=$1 "-" $NF}1' myFile

# 4  
Old 11-05-2012
sorry could you explian more your code
i tried it but i didit get the output needed
thanks

---------- Post updated at 09:47 AM ---------- Previous update was at 09:46 AM ----------

how to add colomn 1 to 3 into a new colomn and separte the content by "-"
# 5  
Old 11-05-2012
Quote:
Originally Posted by biopsy
sorry could you explian more your code
i tried it but i didit get the output needed
thanks
Sorry, I misread the requirement. try this:
Code:
awk '{print $0, $1 "-" $NF}' myFile

# 6  
Old 11-05-2012
thanks
I tried
Code:
awk '{$NF=$1 "-" $NF}1' input >> results

i got :
Code:
1    rs1111    10583  1-0
1    rs1891    10611   1-1
1    rs1807    13302   1-1

---------- Post updated at 09:55 AM ---------- Previous update was at 09:53 AM ----------

my real file looks like :
Code:
CHR     SNP     BP      A1      A2      MAF     NCHROBS PrimaryFirst
1       rs58108140      10583   A       G       .1438   2184    0
1       rs189107123     10611   G       C       .01877  2184    1

and I want a last clomn called chrBP with content of colomn1-colomn3
Code:
CHR     SNP     BP      A1      A2      MAF     NCHROBS PrimaryFirst CHRBP
1       rs58108140      10583   A       G       .1438   2184    0    1-10583
1       rs189107123     10611   G       C       .01877  2184    1    1-10611

---------- Post updated at 09:56 AM ---------- Previous update was at 09:55 AM ----------

okay thanks i will tired right now

Moderator's Comments:
Mod Comment Please use code tags for code and data

Last edited by Scrutinizer; 11-05-2012 at 10:58 AM.. Reason: Code tags
# 7  
Old 11-05-2012
I've misread your requirement.
Please try:
Code:
awk '{print $0, $1 "-" $NF}' myFile

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to use "awk" to print columns from different files in separate columns?

Hi, I'm trying to copy and paste the sixth column from a bunch of files into a single file having each column pasted in separate columns (and not one after each other in just one column.) I tried this code but works only partially because it copied and pasted 50 rows of each column... (6 Replies)
Discussion started by: Frastra
6 Replies

2. Shell Programming and Scripting

Separate columns into different text files

Hi I have large text file consisting of five columns. Sample of the file is give below: ed 2-4 12.0 commons that they depended on. मानवों नष्ट किया जिन पर वो आधारित थे। ed 3-1 12.0 Almost E, but would be over. रचना करीब करीब ई तक जाती है, मगर तब तो नाटक ख़त्म हो... (2 Replies)
Discussion started by: my_Perl
2 Replies

3. Shell Programming and Scripting

Concatenate two columns in a file

Hi i am having one requirement like to concatenate two columns in to one columns, can any one help on this please sample scenario i am placing below COL1,COL2,COL3,COL4 1,A,B,C,D 2,e,f,g,h ouput should be 3 columns like below. COL1,COL2,newcolumns 1,A,B,CD 2,e,f,gh ... (9 Replies)
Discussion started by: bhaskar v
9 Replies

4. Shell Programming and Scripting

How to concatenate 2-columns by 2 -columns for a text file?

Hello, I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between. input file: 1 0 0 1... (10 Replies)
Discussion started by: huiyee1
10 Replies

5. Shell Programming and Scripting

Grouping multiple columns and concatenate

I have a CSV file that goes like this: Name,Group,Email Max,Group1,max@.com Dan,Group2,dan@.com Max,Group3,max@.com Max,Group4,max@.com Dan,Group5,dan@.com Jim,Group6,jim@.comBasically my desired output should be: Name,Group,Email Max,Group1|Group3|Group4,max@.com... (6 Replies)
Discussion started by: jeffreybsu
6 Replies

6. UNIX for Dummies Questions & Answers

Intersect of two columns in two separate files

Hi, I have a file like this: abc def ghi jkl mno My second file is like this (tab delimited): adsad sdfsdf dfdf wads abc dfdsf sdsf jkl sfsdf dsfds sdfd reor zxczd dsf sff Now, I want the code to report the lines (from file2) which have common strings in column 2 with the first... (4 Replies)
Discussion started by: a_bahreini
4 Replies

7. Shell Programming and Scripting

Separate into columns

Hi all I have following kind of data in a file but non separated ESR1 PA156 leflunomide PA450192 CHST3 PA26503 docetaxel tungstate Pa4586; thalidomide Pa34958; I want to separate entries into columns so that I can put into excel sheet in proper arrangement. I want entries... (4 Replies)
Discussion started by: manigrover
4 Replies

8. Shell Programming and Scripting

Concatenate columns from multiple files

Hi all, I want the 2nd column of every file in the directory in a single file with the file name as column header. $cat file1.txt a b c d e f $cat file2.txt f g h g h j $cat file3.txt a b d f g h (2 Replies)
Discussion started by: newbie83
2 Replies

9. Shell Programming and Scripting

Concatenate columns from files

Hi, I have a file1.txt like this: and a file2.txt like this: I wat only append file2.txt to file1.txt and to have something like this: How could i do ? (2 Replies)
Discussion started by: AdminLew
2 Replies

10. Shell Programming and Scripting

concatenate 'n' number of columns in a file

i have a file which may have 'n' number of columns 1 222 fafda 32 afdaf 4343 4343 234 43fdaf 4343 fdd fdfd fdfd fdd fdfd fdfd fdfd fdfd fdfd fdd fdfd fdfd need to concatenate the columns with... (3 Replies)
Discussion started by: mlpathir
3 Replies
Login or Register to Ask a Question