04-23-2013
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
xsil2graphics
XSIL2GRAPHICS(1) User Contributed Perl Documentation XSIL2GRAPHICS(1)
NAME
xsil2graphics - generate scripts to load xsil output data files
SYNOPSIS
xsil2graphics [options] <xsil_file>
DESCRIPTION
Utility program bundled with xmds, used to generate scripts that load simulation output data into either matlab (http://www.mathworks.com)
or scilab (http://www.scilab.org), which are then used to manipulate the results further if necessary and then to present the results
graphically.
Matlab
To generate a matlab m-file, from the xsil file data_file.xsil use the command:
bash$ xsil2graphics data_file.xsil
or
bash$ xsil2graphics --matlab data_file.xsil
Then at the matlab command prompt:
>> data_file
Scilab
To generate a scilab script file, from the xsil file data_file.xsil use the command:
bash$ xsil2graphics --scilab data_file.xsil
Then at the scilab command prompt:
--> exec('data_file.sci')
OPTIONS
-m, --matlab generate matlab m-file script to load data from the xsil data file (the default option)
-s, -scilab generate scilab script file to load data from the xsil data file
-o, --outfile <out_file> specify an alternative output script filename to the default which is the input xsil filename with the .xsil
extension changed to either .m for the matlab m-file or .sci for the scilab script file
EXAMPLES
bash$ xsil2graphics nlse.xsil
Generates the output nlse.m to load the data into matlab
bash$ xsil2graphics -m nlse.xsil
Also generates the output nlse.m but explicitly sets matlab to be the output format
bash$ xsil2graphics --scilab nlse.xsil
Generates the output nlse.sci to load the data into scilab
bash$ xsil2graphics --outfile nlse_new.m nlse.xsil
Generates the output nlse_new.m to load the data into matlab
AUTHORS
Originally written by Greg Collecutt
Maintained by Paul Cochrane with code contributed by Joe Hope
BUGS
No known bugs.
SEE ALSO
xmds(1), loadxsil(1)
http://www.xmds.org
COPYRIGHT
Copyright (C) 2000-2004
Code contributed by Greg Collecutt, Joseph Hope and Paul Cochrane
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
perl v5.8.2 2004-06-21 XSIL2GRAPHICS(1)