10-05-2011
Quote:
Originally Posted by
Olivia
Yeah it worked but is there any other way as because it's been adding first column to the blank rows too
Show us a
representative sample of your input, then, and a
representative sample of your output.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi guys,
Please help me if u have some solution.
I have a file with three columns separated by ':' -
INPUT_FILE
C416722_2 : calin Dirigent : Dirigent
AC4174_6 : Jac : cal_co
TC4260_5 : [no : lin kite
BC426302_1 : [no : calin Dirigent lin
JC426540_3 : lin Pymo_bin : calin
TC428_3 : no7... (4 Replies)
Discussion started by: sam_2921
4 Replies
2. Shell Programming and Scripting
Hi
I have file which contains 5 coulmns i need to add the fifth column value and put it in the desired location in the same column.
Here is the sample file..
ashop0004 SQL- 06/14/2009 06/14/2009 00:04:28 SUM
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:37 ... (22 Replies)
Discussion started by: cutechaps
22 Replies
3. Shell Programming and Scripting
So I have this input
1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI
1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI
1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI
1 10583 rs58108140 G A ... (3 Replies)
Discussion started by: kellywilliams
3 Replies
4. Shell Programming and Scripting
Hi, long time reader, first time poster.
I've done some searching so please if this is a repeated post excuse the duplicate, but what I have are two files roughly like so:
File 1:
A W
B X
C Y
D Z
File 2:
A 1
C 2
D 3
And what I would like to get out is... (4 Replies)
Discussion started by: wallysb01
4 Replies
5. Shell Programming and Scripting
Dear all,
Lets say, I've a file a.txt containing two columns, like
a1 b1
.. ..
.. ..
and another file b.txt containg two columns, like
a1 c1
.. ..
.. ..
I need to put c1 column from b.txt file to the a.txt file. So, the output should be
a1 b1 c1
.. .. ..
.. ... (4 Replies)
Discussion started by: mkg
4 Replies
6. Shell Programming and Scripting
Input File 1
cat S1.txt
MI0043 2731 miR-1
Input File 2
cat S4.txt
MI006 310 CiR-1
MI057 10 CiR-24
MI750 5 CiR-24
Desired Output File 1
cat S1.txt.out
MI0043 2731 miR-1 S1.txt
Desired Output File 2
cat S4.txt.out
MI006 310 CiR-1 S4.txt (3 Replies)
Discussion started by: perl_beginner
3 Replies
7. Shell Programming and Scripting
I have file like this
b,c
10,20
30,40
50,60
Now I want to add a new column a with fixed values for all the rows
a,b,c
60,10,20
60,30,40
60,50,60
Please let me know how can we do this in unix. (4 Replies)
Discussion started by: weknowd
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have this data file that contains:
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H
9 I
I want the results to be:
1 A A
2 B A
3 C A
4 D A
5 E A
6 F A
7 G A
8 H A (8 Replies)
Discussion started by: bobo
8 Replies
9. Shell Programming and Scripting
Hi Team
I have file as below
empno,ename,sal
123,smith,1000
124,adams,2000
Required output: Using AWK
empno,ename,sal,deptno
123,smith,1000
124,adams,2000
Thanks,
Murali (5 Replies)
Discussion started by: bmk
5 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have 2 files.
file1 contains by lines: hash:salt:id
file2 contains by lines: username:hash:salt
I would like to add a new coloumn (id) form file1 to file2.
The new file should contains: username:hash:salt:id
Note: file1 contains less rows than file2.
I tried
paste -d':' file1... (12 Replies)
Discussion started by: freeroute
12 Replies
LEARN ABOUT DEBIAN
catcodec
CATCODEC(1) BSD General Commands Manual CATCODEC(1)
NAME
catcodec -- An open source tool to decode/encode the sample catalogue for OpenTTD
SYNOPSIS
catcodec [-d sample_file] [-e sample_file]
DESCRIPTION
catcodec decodes and encodes sample catalogues for OpenTTD. These sample catalogues are not much more than some meta-data (description and
file name) and raw PCM data.
Decoding a sample catalogue, e.g. sample.cat, results in a sample.sfo that contains the file names and descriptions of the samples and all
samples with the file name as specified in the catalogue.
Encoding a sample catalogue, e.g. sample.cat, reads sample.sfo for the file names and descriptions. It will then load the samples described
in sample.sfo and encodes these into sample.cat.
Generally speaking encoding a file and then decoding it results in the same file. Decoding of the original, Transport Tycoon Deluxe, sample
format will force the output to be 11025 Hz, 8 bits mono because the meta-data of some of the samples is incorrect or even missing.
Only PCM WAVE files with only the format and data chunks are supported. Any other formats need to be converted into this. Furthermore only
11025 Hz, 22050 Hz and 44100 Hz with 8 or 16 bits per sample single channel PCM WAVE files are supported.
OPTIONS
-d sample_file Decode the given sample catalogue into its components. The sample_file must have the extension '.cat'. For the output meta-
data file the '.cat' is replaced with '.sfo'. The actual samples, in PCM WAVE format, are extracted into files using the file
names, including extension, as described in the catalogue or meta-data file.
If any of the files already exists a backup is made, by adding '.bak', overwriting the existing backup.
-e sample_file Encode the components for the given sample file into a sample catalogue. The sample_file must have the extension '.cat'. For
the input meta-data file the '.cat' is replaced with '.sfo'. The actual samples, in PCM WAVE format, are read from files
using the file names, including extension, as described in the meta-data file.
If the sample_file already exists a backup is made, by adding '.bak', overwriting the existing backup.
SEE ALSO
openttd(1) the game that uses these sample catalogues.
AUTHORS
Remko Bijker <rubidium@openttd.org>
November 05, 2009