03-05-2014
Dear all,
Thank for the code. I know it can be done with awk. However, I have to concatenate for 200,000 columns. Is there any code to concatenate all 200,000 columns?
Many thanks.
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Discussion started by: Unilearn
6 Replies
2. Shell Programming and Scripting
i have a file which may have 'n' number of columns
1 222 fafda 32 afdaf 4343 4343
234 43fdaf 4343 fdd fdfd fdfd fdd fdfd fdfd
fdfd fdfd fdfd fdd fdfd fdfd
need to concatenate the columns with... (3 Replies)
Discussion started by: mlpathir
3 Replies
3. Shell Programming and Scripting
Hi,
I have a file1.txt like this:
and a file2.txt like this:
I wat only append file2.txt to file1.txt
and to have something like this:
How could i do ? (2 Replies)
Discussion started by: AdminLew
2 Replies
4. UNIX for Dummies Questions & Answers
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies
5. Shell Programming and Scripting
Hi all,
I want the 2nd column of every file in the directory in a single file with the file name as column header.
$cat file1.txt
a b c
d e f
$cat file2.txt
f g h
g h j
$cat file3.txt
a b d
f g h (2 Replies)
Discussion started by: newbie83
2 Replies
6. UNIX for Advanced & Expert Users
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
7. UNIX for Dummies Questions & Answers
hi all
could you please help me to concatenate two colomns and separate them by "-"
the two colomns to concatenate are colomuns 1 and 3 of a very bif file
clomn 1 is chr, 2 is snp and 3 is bp
the new colomn is chr_B
input file :
1 rs1111 10583
1 rs1891 10611
1 rs1807 ... (13 Replies)
Discussion started by: biopsy
13 Replies
8. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
9. Shell Programming and Scripting
I have a CSV file that goes like this:
Name,Group,Email
Max,Group1,max@.com
Dan,Group2,dan@.com
Max,Group3,max@.com
Max,Group4,max@.com
Dan,Group5,dan@.com
Jim,Group6,jim@.comBasically my desired output should be:
Name,Group,Email
Max,Group1|Group3|Group4,max@.com... (6 Replies)
Discussion started by: jeffreybsu
6 Replies
10. Shell Programming and Scripting
Hi
i am having one requirement like to concatenate two columns in to one columns, can any one help on this please sample scenario i am placing below
COL1,COL2,COL3,COL4
1,A,B,C,D
2,e,f,g,h
ouput should be 3 columns like below.
COL1,COL2,newcolumns
1,A,B,CD
2,e,f,gh
... (9 Replies)
Discussion started by: bhaskar v
9 Replies
LEARN ABOUT DEBIAN
concat
concat(3tcl) Tcl Built-In Commands concat(3tcl)
__________________________________________________________________________________________________________________________________________________
NAME
concat - Join lists together
SYNOPSIS
concat ?arg arg ...?
_________________________________________________________________
DESCRIPTION
This command joins each of its arguments together with spaces after trimming leading and trailing white-space from each of them. If all
the arguments are lists, this has the same effect as concatenating them into a single list. It permits any number of arguments; if no args
are supplied, the result is an empty string.
EXAMPLES
Although concat will concatenate lists, flattening them in the process (so giving the following interactive session):
% concat a b {c d e} {f {g h}}
a b c d e f {g h}
it will also concatenate things that are not lists, as can be seen from this session:
% concat " a b {c " d " e} f"
a b {c d e} f
Note also that the concatenation does not remove spaces from the middle of values, as can be seen here:
% concat "a b c" { d e f }
a b c d e f
(i.e., there are three spaces between each of the a, the b and the c).
SEE ALSO
append(3tcl), eval(3tcl), join(3tcl)
KEYWORDS
concatenate, join, lists
Tcl 8.3 concat(3tcl)