|
|
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 REDHAT
mac2unix
dos2unix(1) General Commands Manual dos2unix(1) NAME
dos2unix - DOS/MAC to UNIX text file format converter SYNOPSYS
dos2unix [options] [-c convmode] [-o file ...] [-n infile outfile ...] Options: [-hkqV] [--help] [--keepdate] [--quiet] [--version] DESCRIPTION
This manual page documents dos2unix, the program that converts plain text files in DOS/MAC format to UNIX format. OPTIONS
The following options are available: -h --help Print online help. -k --keepdate Keep the date stamp of output file same as input file. -q --quiet Quiet mode. Suppress all warning and messages. -V --version Prints version information. -c --convmode convmode Sets conversion mode. Simulates dos2unix under SunOS. -o --oldfile file ... Old file mode. Convert the file and write output to it. The program default to run in this mode. Wildcard names may be used. -n --newfile infile outfile ... New file mode. Convert the infile and write output to outfile. File names must be given in pairs and wildcard names should NOT be used or you WILL lost your files. EXAMPLES
Get input from stdin and write output to stdout. dos2unix Convert and replace a.txt. Convert and replace b.txt. dos2unix a.txt b.txt dos2unix -o a.txt b.txt Convert and replace a.txt in ASCII conversion mode. Convert and replace b.txt in ISO conversion mode. Convert c.txt from Mac to Unix ascii format. dos2unix a.txt -c iso b.txt dos2unix -c ascii a.txt -c iso b.txt dos2unix -c mac a.txt b.txt Convert and replace a.txt while keeping original date stamp. dos2unix -k a.txt dos2unix -k -o a.txt Convert a.txt and write to e.txt. dos2unix -n a.txt e.txt Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt. dos2unix -k -n a.txt e.txt Convert and replace a.txt. Convert b.txt and write to e.txt. dos2unix a.txt -n b.txt e.txt dos2unix -o a.txt -n b.txt e.txt Convert c.txt and write to e.txt. Convert and replace a.txt. Convert and replace b.txt. Convert d.txt and write to f.txt. dos2unix -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt DIAGNOSTICS
BUGS
The program does not work properly under MSDOS in stdio processing mode. If you know why is that so, please tell me. AUTHORS
Benjamin Lin - <blin@socs.uts.edu.au> Bernd Johannes Wuebben (mac2unix mode) <wuebben@kde.org> MISCELLANY
Tested environment: Linux 1.2.0 with GNU C 2.5.8 SunOS 4.1.3 with GNU C 2.6.3 MS-DOS 6.20 with Borland C++ 4.02 Suggestions and bug reports are welcome. SEE ALSO
unix2dos(1) mac2unix(1) 1995.03.31 dos2unix v3.0 dos2unix(1)