Sponsored Content
Top Forums Shell Programming and Scripting Extract columns based on header Post 302797861 by aec on Tuesday 23rd of April 2013 09:51:27 AM
Old 04-23-2013
Hope now is clearer
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract columns where header matches a given string

Hi, I'm having trouble pulling out columns where the headers match a file of key ID's I'm interested in and was looking for some help. file1.txt I Name 34 56 84 350 790 1215 1919 7606 9420 file2.txt I Name 1 1 2 2 3 3 ... 34 34... 56 56... 84 84... 350 350... M 1 A A A A... (20 Replies)
Discussion started by: flotsam
20 Replies

2. UNIX for Dummies Questions & Answers

Printing columns with header

Hi Gurus, I want to extract certain columns from file 2 and combine with file 1. I am using the following script to extract the columns. $ awk 'FNR>1{print $2, $9, FILENAME}' *.lim > out1 However, this script does not print the titles of the columns 2 and 9. Can somebody help me in... (1 Reply)
Discussion started by: Unilearn
1 Replies

3. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

4. UNIX for Dummies Questions & Answers

Extract columns based on the first line of each column

Sorry to bother you guys again. I have a file1 with multiple columns like this:gga_miR_100 gga_miR_300 gga_miR_3500 gga_miR_4600 gga_miR_5600 gga_miR_30 gga_miR_500 kj rwg ghhh jy jyu we vf 5g 5hg h6 56h i8 45t 44r4 4bg 4r546 9lgtr (fer) 4fr f433 3feev f4 bf4 35g vfr ge 2rr ... (5 Replies)
Discussion started by: yuejian
5 Replies

5. Shell Programming and Scripting

Make copy of text file with columns removed (based on header)

Hello, I have some tab delimited text files with a three header rows. The headers look like, (sorry the tabs look so messy). index group Name input input input input input input input input input input input... (9 Replies)
Discussion started by: LMHmedchem
9 Replies

6. Shell Programming and Scripting

Add new columns based on existing columns

Hi all, I am kind of stuck with printing my desired output. Please help me if you know how it can work. My input file(tab separated): NW_0068.1 41,16 100,900 NW_0699.1 4,2,19 200,700,80 My Output file (desired): NW_0068.1 41,16 100,900 100 - 141 NW_0068.1 41,16 100,900 ... (3 Replies)
Discussion started by: sam_2921
3 Replies

7. Emergency UNIX and Linux Support

Average columns based on header name

Hi Friends, I have files with columns like this. This sample input below is partial. Please check below for main file link. Each file will have only two rows. ... (8 Replies)
Discussion started by: jacobs.smith
8 Replies

8. UNIX for Beginners Questions & Answers

Keep only columns in first two rows based on partial header pattern.

I have this code below that only prints out certain columns from the first two rows (doesn't affect rows 3 and beyond). How can I do the same on a partial header pattern “G_TP” instead of having to know specific column numbers (e.g. 374-479)? I've tried many other commands within this pipe with no... (4 Replies)
Discussion started by: aachave1
4 Replies

9. Shell Programming and Scripting

Find columns in a file based on header and print to new file

Hello, I have to fish out some specific columns from a file based on the header value. I have the list of columns I need in a different file. I thought I could read in the list of headers I need, # file with header names of required columns in required order headers_file=$2 # read contents... (11 Replies)
Discussion started by: LMHmedchem
11 Replies

10. Shell Programming and Scripting

To extract certain columnns with header

Hi, I have data which has many columns but i need to extract only three column from below all records have one space in begining. i need to extract only column as below ,any tric awk or sed trick?, please advise. cloumn no : 3 : ORD NO coulmn no : 6: P A R T N U M B E R coulmn no : 9 :... (7 Replies)
Discussion started by: Riverstone
7 Replies
MooseX::Has::Sugar::Saccharin(3pm)			User Contributed Perl Documentation			MooseX::Has::Sugar::Saccharin(3pm)

NAME
MooseX::Has::Sugar::Saccharin - Experimental sweetness VERSION
version 0.05070420 SYNOPSIS
This is a highly experimental sugaring module. No Guarantees of stability. use MooseX::Types::Moose qw( :all ); has name => rw Str, default { 1 }; has suffix => required rw Str; has 'suffix', required rw Str; Your choice. EXPORT GROUPS
:default exports "ro", "rw", "required", "lazy", "lazy_build", "coerce", "weak_ref", "auto_deref", "bare", "default", "init_arg", "predicate", "clearer", "builder", "trigger", EXPORTED FUNCTIONS
bare bare $Type bare Str equivalent to this is => 'bare', isa => Str ro ro $Type ro Str equivalent to this is => 'ro', isa => Str, rw rw $Type rw Str equivalent to this is => 'rw', isa => Str required required @rest this required rw Str is equivalent to this required => 1, is => 'rw', isa => Str, this rw Str, required is equivalent to this is => 'rw', isa => Str , required => 1 lazy lazy @rest like "( lazy => 1 , @rest )" lazy_build lazy_build @rest like "( lazy_build => 1, @rest )" weak_ref weak_ref @rest like "( weak_ref => 1, @rest )" coerce @rest like "( coerce => 1, @rest )" WARNING: Conflicts with "MooseX::Types's" "coerce" method auto_deref auto_deref @rest like "( auto_deref => 1, @rest )" builder builder $buildername: required rw Str, builder '_build_foo' is like builder => '_build_foo' predicate predicate $predicatename see "builder" clearer clearer $clearername see "builder" init_arg init_arg $argname see "builder" default default { $code } Examples: default { 1 } default { { } } default { [ ] } default { $_->otherfield } $_ is localised as the same value as $_[0] for convenience ( usually $self ) trigger trigger { $code } Works exactly like default. CONFLICTS
MooseX::Has::Sugar MooseX::Has::Sugar::Minimal This module is not intended to be used in conjunction with ::Sugar or ::Sugar::Minimal We export many of the same symbols and its just not very sensible. MooseX::Types Moose::Util::TypeConstraints due to exporting the "coerce" symbol, using us in the same scope as a call to use MooseX::Types .... or use Moose::Util::TypeConstraints will result in a symbol collision. We recommend using and creating proper type libraries instead, ( which will absolve you entirely of the need to use MooseX::Types and MooseX::Has::Sugar(::*)? in the same scope ) Perl 5.010 feature 'switch' the keyword 'default' becomes part of Perl in both these cases: use 5.010; use feature qw( :switch ); As such, we can't have that keyword in that scenario. AUTHOR
Kent Fredric <kentnl at cpan.org> COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Kent Fredric. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.14.2 2012-02-12 MooseX::Has::Sugar::Saccharin(3pm)
All times are GMT -4. The time now is 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy