Hi all
I have data in following format:
CSCH74,2007,1,09103,15
CSCH74,2007,10,09103,0
CSCH74,2007,11,09103,0
CSCH74,2007,12,09103,0
CSCH74,2007,2,09103,15
CSCH74,2007,3,09103,194
CSCH74,2007,4,09103,115
CSCH74,2007,5,09103,66
CSCH74,2007,6,09103,0
CSCH74,2007,7,09103,0... (2 Replies)
Hope someone can help,
I am trying to sort a generic file like this
test2 A 468 0
test2 R 468 1
test2 E 468 1
test2 R 468 3
test2 R 468 4
test2 R 468 459
test2 Z 468 0
test1 A 191 0
test1 R 191 191
test1 Z 191 0
test3 A 3 0
test3 R 3 3
test3 Z 3 0
test0 A 1 0
test4 A 1 0
test4 E... (2 Replies)
Greetings,
I have an input file with two columns. The first column has different codes. Each time I have a new code I need to split the columns into new ones. The input file looks like this
CR124 1320
CR124 1138
CR124 682
CR124 629
CR124 592
CR124 580
CR124 537
CR161 3967... (2 Replies)
Greetings,
I have an input file with two columns. The first column has different codes. Each time I have a new code I need to split the columns into new ones. The input file looks like this
CR124 1320
CR124 1138
CR124 682
CR124 629
CR124 592
CR124 580
CR124 537
CR161 3967
CR161 3656... (6 Replies)
Hi,
I have a file /tmp/1.txt. (Space b/w the fields are not equal)
#cat 1.txt
35G 22G 13G 64% /mount1
15G 7.1G 7.5G 49% /mount2
2G 9.9G 4.7G 68% /mount3
15G 9.1G 5G 63% /mount4
i want to wite a script to display these values as below.
O/P:
35G-22G-13G-64%-/mount1... (15 Replies)
hi all,
i have a file like thsi
a 1 3;4
b 2 4;7
c 4 5;6
d 4 5;8
now i want 1st, 2nd and in 3rd column i want only 1st column
the output should be like below
a 1 3
b 2 4
c 4 5
d 4 5
I need it in perl; please dont write in Shell scripting (1 Reply)
Hi, all.
How can I split all columns into multiple columns separated by tab?
Input:
qq ee TT 12 m1
aa gg GG 34 2u
zz dd hh 56 4h
ww cc JJ 78 5y
ss ff kk 90 j8
xx pp mm 13 p0
Output:
q q e e T T 1 2 m 1
a a g g G G 3 4 2 u
z z d d h h 5 6 4 h
w w c c J J 7 8 5 y (8 Replies)
I have a big data set as follows
8.519 8.601 8.833 9.183 9.602
1.003 1.041 1.070 1.085 1.084
1.06 1.034 9.879 9.307 8.66
I simply want this to arrange like this
8.519 8.601 8.833
9.183 9.602 1.003
1.041 1.070 1.085
1.084 1.06 1.034
9.879 9.307 8.66 ... (2 Replies)
Any one can help me in converting columns into rows.
example
I have input file
10000|
10002|
10003|
10004|
10005|
I want output in below format
PARTY|PART_DT
10000|12080000000
10002|13075200000
10003|13939200000
10004|1347200000
10004|133600000
10004|1152000000 (13 Replies)