10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
Hello,
I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between.
input file:
1 0 0 1... (10 Replies)
Discussion started by: huiyee1
10 Replies
3. 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
4. Shell Programming and Scripting
How to find the number of columns in xml file.
i tried following command.
#!bin/ksh
cat $1 | grep -c "</mdm:attribute>"
exit 0
but i am not getting accurate result which is not matching with the manual count.
data format :
<mdm:attribute> value </mdm:attribute> (6 Replies)
Discussion started by: victory
6 Replies
5. AIX
How to find the number of columns in xml file.
i tried following command.
Code:
#!bin/ksh
cat $1 | grep -c "</mdm:attribute>"exit 0but i am not getting accurate result which is not matching with the manual count.
data format :
Code:
<mdm:attribute> value </mdm:attribute>
No... (1 Reply)
Discussion started by: victory
1 Replies
6. 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
7. 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
8. 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
9. Shell Programming and Scripting
This should follow with my last post but I think it's better to start a new one. Now I have a list of numbers stored in pos.txt:
2
6
7
.
.
.
n
.
.
.
And I need to extract (2n-1, 2n) columns from matrix.txt:
ind1 A B C D E F G H I J K L M N O P Q R ...
ind2 B C D E F G H... (3 Replies)
Discussion started by: Zoho
3 Replies
10. UNIX for Dummies Questions & Answers
Hi all,
may seem a very stupid question.but me stuck up in it for long....
How to find the number of columns in a ASCII file.
EX:-Demo.lst
songs 1 34 45 67
Number of columns should be 5.
Regards,
Anindya
;) (13 Replies)
Discussion started by: rahul26
13 Replies