|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Combined many txt files by columns
Post 302326412 by AMBER on Thursday 18th of June 2009 01:21:43 AM
06-18-2009
How to combine 500 .txt files when the default is 12 using 'paste'?
Hi,
I want to combined 500 .txt files (each file only has one line) to a single txt file (A.txt).
for example,
A1.txt with
12
23
34
45
A2.txt with
56
67
78
89
...etc, so I have A1.txt, A2.txt... , A499.txt, A500.txt
so the results suppose to be A.txt with
12 56 .... (500 columns)
23 67 .... (500 columns)
34 78 .... (500 columns)
45 89 .... (500 columns)
I use "paste A* > A.txt", but it seems that there are too many files to be combined, but unix only allows 12 files to put together.
Are there any other ways to do it?
Thanks a lot~!
I want to combined 500 .txt files (each file only has one line) to a single txt file (A.txt).
for example,
A1.txt with
12
23
34
45
A2.txt with
56
67
78
89
...etc, so I have A1.txt, A2.txt... , A499.txt, A500.txt
so the results suppose to be A.txt with
12 56 .... (500 columns)
23 67 .... (500 columns)
34 78 .... (500 columns)
45 89 .... (500 columns)
I use "paste A* > A.txt", but it seems that there are too many files to be combined, but unix only allows 12 files to put together.
Are there any other ways to do it?
Thanks a lot~!
Last edited by AMBER; 06-18-2009 at 03:41 AM..
|
|
10 More Discussions You Might Find Interesting
1. Solaris
Dear experts,
In a directory i have both *.TXT and *.txt files. I have a script-
for file in `ls *.txt`; do
mv $file /tmp/$file
How to list both *.txt and*.TXT file in one command so that script will move both .txt or .TXT whatever it find.
br//purple (4 Replies)
Discussion started by: thepurple
4 Replies
2. UNIX for Dummies Questions & Answers
Hi
I have a txt file with 4 columns where I need to add 4 empty columns in the middle meaning that I need what is currently column 4 to be column 8 in a new file.
The idea is that I have to use the file as input in a program that reads the data in column 1 and 8, so the content of the other... (8 Replies)
Discussion started by: Banni
8 Replies
3. UNIX for Dummies Questions & Answers
Dear all,
I have a question. I have a txt.file as below. i want to add 3 more columns: column3=conlum 2*column2; column4=(1-column2)*(1-column2); column5=1-column3-column4. Do you know how to do it? Thanks a lot!
file:
column1 column2
a 1
b 20
c 30
d 3
... (2 Replies)
Discussion started by: forevertl
2 Replies
4. Shell Programming and Scripting
hello,
i have publicly available txt file with little less than 300000 rows. i want to extract from column 1 to column 218 and save it in another text file. i use the cut command but the file is saved with multiple rows from the source file onto a single row in the destination. basically it is... (6 Replies)
Discussion started by: madrazzii
6 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I would like to send below output in a tabular column ( xml or excel ) and send a mail.
vinay unix
anil sql
vamsee java
request to suggest a solution. (1 Reply)
Discussion started by: Girish19
1 Replies
6. Shell Programming and Scripting
Hi,
Below are the sample data for txt files.
txt file 1
Partnumber|catgroup_id
10001082|46016
10001093|4680
10001093|386003
10001093|463004
10003251|683
10003251|63005
10003252|463005
10003252|4683
10003260|463005
10003260|4683
10003264|4683
10003264|463005
13420000|67... (5 Replies)
Discussion started by: Ankita Talukdar
5 Replies
7. Shell Programming and Scripting
Hi,
I have a txt file that looks like
log2FoldChange Ontology_term
8.50624450251828 GO:0003700,GO:0003707,GO:0005634,GO:0006355,GO:0043401,GO:0003700,GO:0005634,GO:0006355,GO:0008270,GO:0043565
7.03936870356684 GO:0005515,GO:0008080
6.49606183738682
6.49525073909629 GO:0005515... (4 Replies)
Discussion started by: alisrpp
4 Replies
8. Shell Programming and Scripting
I have 133 .txt files in a directory that I am combining into 1 file. The problem is when I use awk or cat to combine the files I get out put like this:
output
85 138662360 KCNT1
86 138662962 KCNT1
82 138657053 KCNT1
83 138657635 KCNT1
95 138646881 KCNT1... (12 Replies)
Discussion started by: cmccabe
12 Replies
9. Shell Programming and Scripting
Hi dears
i use bash shell
i have INPUT.txt
like this
number of columns different in one
some row have 12 , some 11 columns
see last column
INPUT.txt
CodeGender Age Grade Dialect Session Sentence Start End Length Phonemic Phonetic
63 M 27 BS/BA TEHRANI 3 4 298320 310050... (2 Replies)
Discussion started by: alii
2 Replies
10. Shell Programming and Scripting
Hi folks
I need/want to redirect output (stdout, stderr) from an exec call to separate files. One for stderr only and two(!) different (!) ones for the combined output of stderr and stdout.
After some research and testing i got this so far :
(( exec ${command} ${command_parameters} 3>&1... (6 Replies)
Discussion started by: MDominok
6 Replies
LEARN ABOUT DEBIAN
gtkdoc-mktmpl
gtkdoc-mktmpl(1) General Commands Manual gtkdoc-mktmpl(1) NAME
gtkdoc-mktmpl -- GTK DocBook documentation generator. SYNOPSIS
gtkdoc-mktmpl [ See below ] DESCRIPTION
gtkdoc-mktmpl This creates or updates the template files which contain the manually-edited documentation. (A template is a simple text form which is filled in with the description of a function, macro, enum, or struct. For functions and macros it also contains fields for describing the parameters.) This script reads in the existing templates, found in tmpl/*.sgml, moves these files to tmpl/*.sgml.bak, and then recreates the .sgml files according to the structure given in the file MODULE-sections.txt. Any new templates added, or new function parameters, are marked with FIXME so you can do a grep to see which parts need updating. Any templates which are no longer used (i.e. they are remove from MODULE-sections.txt) are placed in the file tmpl/MODULE-unused.txt. If they are included again later they are automatically copied back into position. If you are certain that these templates will never be used again you can delete them from MODULE-unused.txt. Any parameters to functions which are no longer used are separated from the rest of the parameters with the line <!-- # Unused Parameters # -->. It may be that the parameter name has just been changed, in which case you can copy the description to the parameter with the new name. You can delete the unused parameter descriptions when no longer needed. EXAMPLE
See /usr/share/doc/gtk-doc-tools/examples, for a makefile.am and a configure.in example file. AUTHOR
This manual page was written by Christian Marillat marillat@debian.org for the Debian GNU/Linux system (but may be used by others). gtkdoc-mktmpl(1)