01-22-2012
add (append) a column in a tab delimited file
I have a file having the following entries:
test1 test2 test3
11 22 33
22 44 66
99 99 44
---
I want to add a column so that the above file becomes:
test1 test2 test3 notest
11 22 33 *
22 44 66 *
99 99 44 *
---
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a large text-file with tab-delimited genetic data that looks like:
KSC112 KSC234 0 0 1 1 A G C T
I simply wan to delete the first column, but since the file has 600 000 columns, it is not possible with awk (seems to be limited at 32k columns).
Does anyone have an idea how to do this? (2 Replies)
Discussion started by: andmal
2 Replies
2. Shell Programming and Scripting
Hi,
I have the below flat filewith ~ as delimiter
emp.no~dept.name
I need to append corresponding emp.name column which will come from database based on emp.no in the flat file.
I need the output as
dept.name~emp.name
Can anyone please help me in resolving this issue..
I tried the... (2 Replies)
Discussion started by: siri_886
2 Replies
3. UNIX for Dummies Questions & Answers
I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
4. Shell Programming and Scripting
Hi all,
I'm new to Unix and work primarily in bioinformatics. I am in need of a script which will allow me to replace "1" with "chr1" in only the first column of a file which looks like such:
1 10327 rs112750067 T C . PASS ASP;RSPOS=10327;... (4 Replies)
Discussion started by: Hkins552
4 Replies
5. Shell Programming and Scripting
I have a file which looks like this:
73450 articles and news developmental psychology 2006-03-30 16:22:40 1 http://www.usnews.com
73450 articles and news developmental psychology 2006-03-30 16:22:40 2 http://www.apa.org
73450 articles and news developmental psychology 2006-03-30... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies
6. Shell Programming and Scripting
Dear All,
I would like to find an automatic way to add a given code which belong to a class at the end of the column , for example this is my input file:
0610009O20Rik
V$VMYB_01 310 (+) 1 0.971 v-Myb
V$EVI1_04 782 (-) 0.763 0.834 Evi-1
V$ELK1_02 1966 (-) 1 0.984 Elk-1... (4 Replies)
Discussion started by: paolo.kunder
4 Replies
7. Shell Programming and Scripting
Hi all,
I have a 3 columns input file like this:
CPLX9PC-4943 CPLX9PC-4943 1
CPLX9PC-4943 CpxID123 0
CPLX9PC-4943 CpxID126 0
CPLX9PC-4943 CPLX9PC-5763 0.5
CPLX9PC-4943 CpxID13 0
CPLX9PC-4943 CPLX9PC-6163 0
CPLX9PC-4943 CPLX9PC-6164 0.04... (7 Replies)
Discussion started by: AshwaniSharma09
7 Replies
8. Shell Programming and Scripting
Hi,
Can anyone please tell me about how we can delete an entire column from a tab delimited file?
Mu input_file.txt looks like this:
And I want the output as:
I used the below code
nawk -v d="1" 'BEGIN{FS=OFS="\t"}{$d=""}{print}' input_file.txtBut in the output, the first column is... (5 Replies)
Discussion started by: sampoorna
5 Replies
9. Shell Programming and Scripting
Hi,
I have a data like
Input:
12||34|56|78
Output:
XYZ|12||34|56|78
I tried like this , but it puts it on another line
awk -F "|" ' BEGIN {"XYZ"} {print $0} 'file
Any quick suggessitons in sed/awk ? am using HP-UX (3 Replies)
Discussion started by: selvankj
3 Replies
10. UNIX for Beginners Questions & Answers
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
LEARN ABOUT DEBIAN
bup-restore
bup-restore(1) General Commands Manual bup-restore(1)
NAME
bup-restore - extract files from a backup set
SYNOPSIS
bup restore [--outdir=outdir] [-v] [-q]
DESCRIPTION
bup restore extracts files from a backup set (created with bup-save(1)) to the local filesystem.
The specified paths are of the form /branch/revision/path/to/file. The components of the path are as follows:
branch the name of the backup set to restore from; this corresponds to the --name (-n) option to bup save.
revision
the revision of the backup set to restore. The revision latest is always the most recent backup on the given branch. You can dis-
cover other revisions using bup ls /branch.
/path/to/file
the original absolute filesystem path to the file you want to restore. For example, /etc/passwd.
Note: if the /path/to/file is a directory, bup restore will restore that directory as well as recursively restoring all its contents.
If /path/to/file is a directory ending in a slash (ie. /path/to/dir/), bup restore will restore the children of that directory directly to
the current directory (or the --outdir). If the directory does not end in a slash, the children will be restored to a subdirectory of the
current directory. See the EXAMPLES section to see how this works.
OPTIONS
-C, --outdir=outdir
create and change to directory outdir before extracting the files.
-v, --verbose
increase log output. Given once, prints every directory as it is restored; given twice, prints every file and directory.
-q, --quiet
don't show the progress meter. Normally, is stderr is a tty, a progress display is printed that shows the total number of files
restored.
EXAMPLE
Create a simple test backup set:
$ bup index -u /etc
$ bup save -n mybackup /etc/passwd /etc/profile
Restore just one file:
$ bup restore /mybackup/latest/etc/passwd
Restoring: 1, done.
$ ls -l passwd
-rw-r--r-- 1 apenwarr apenwarr 1478 2010-09-08 03:06 passwd
Restore the whole directory (no trailing slash):
$ bup restore -C test1 /mybackup/latest/etc
Restoring: 3, done.
$ find test1
test1
test1/etc
test1/etc/passwd
test1/etc/profile
Restore the whole directory (trailing slash):
$ bup restore -C test2 /mybackup/latest/etc/
Restoring: 2, done.
$ find test2
test2
test2/passwd
test2/profile
SEE ALSO
bup-save(1), bup-ftp(1), bup-fuse(1), bup-web(1)
BUP
Part of the bup(1) suite.
AUTHORS
Avery Pennarun <apenwarr@gmail.com>.
Bup unknown- bup-restore(1)