03-05-2011
Thanks for the neat solution!
It turns out that the tab file requires a tab between the two column so I edited a bit.
awk '{v=($1==x)?v FS $2:v RS $1"\t"$2;x=$1}END{print v}' in_file > out_file
Thanks to Corona688 too!
By the way anyone knows how to mark this thread as [SOLVED]?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I just set up an ftp server with Red Hat 5.2. I am doing the work, I'm baby stepping, but it seems like every step I get stuck. Currently, I'm trying to set up a crontab job, but I'm getting the following message: /bin/sh: /usr/bin/vi: No such file or directory. I see that vi exists in /bin/vi,... (3 Replies)
Discussion started by: kwalter
3 Replies
2. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I have a file with single white space delimited values, I want to convert them to a tab delimited file.
I tried sed, tr ... but nothing is working.
Thanks,
Rajeevan D (16 Replies)
Discussion started by: jeevs81
16 Replies
4. Shell Programming and Scripting
Hi all, I need help to split a tab-delimited list into separate files by the filename-field. The list is already sorted ascendingly by filename, an example list would look like this;
filename001 word1 word2
filename001 word3 word4
filename002 word1 word2
filename002 word3 word4... (4 Replies)
Discussion started by: perkele
4 Replies
5. UNIX for Dummies Questions & Answers
How do I use awk to log transform the fifth column of a tab-delimited text file? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
6. Shell Programming and Scripting
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies
7. Shell Programming and Scripting
Hello folks
I have a txt file of information about journal articles from different fields. I need to convert this information into a format that is easier for computers to manipulate for some research that I'm doing on how articles are cited. The file has some header information and then details... (8 Replies)
Discussion started by: ksk
8 Replies
8. Shell Programming and Scripting
Hi,
Needs for statistics, doing converting
Here is a sample file
Input :
1|A|17,94
1|B|22,59
1|C|56,93
2|A|63,71
2|C|23,92
5|B|19,49
5|C|67,58
expecting something like that
Output :
1|A|17,94|B|22,59|C|56,93
2|A|63,71|B|0|C|23,92
5|A|0|B|19,49|C|67,58 (11 Replies)
Discussion started by: fastlane3000
11 Replies
9. Shell Programming and Scripting
there are two directories A and B
if cmd in in "A/user/bin A/bin A/user/sbin" but not "B/user/bin B/bin B/user/sbin" directory print them (1 Reply)
Discussion started by: yanglei_fage
1 Replies
10. UNIX for Beginners Questions & Answers
Hi there,
I would like to use awk to reformat a tab-delimited file containing three columns as follows:
Data file:
sample 1 173
sample 269 530
sample 687 733
sample 1699 1779
Desired output file:
sample 174..265, 531..686, 734..1698
I need the value... (5 Replies)
Discussion started by: emiley
5 Replies
CDTOA(1) General Commands Manual CDTOA(1)
NAME
cdtoa - To convert the binary format of a dictionary back to
text format.
SYNOPSIS
cdtoa [-n] [-s] [-z] [-e] [-E] infilename
[-h cixingfile ] [ usagefreqfile ]
DEFAULT PATH
/usr/local/bin/cWnn4/cdtoa
DESCRIPTION
To convert the binary format of the dictionary to text
format, and output to standard output(stdout).
infilename is the name of the input binary format
dictionary.
The output may be piped into a file by using the ">"
command. For example,
cdtoa dict.dic > dict.u
"dict.u" here is the output text format dictionary, while the "dict.dic" is the input binary format dictionary.
usagefreqfile may indicate more than one user usage frequency files (for a particular user). These usage frequency information will be
reflected in the text format dictionary created.
OPTIONS
-s To order the entries in text dictionary according to Pinyin or Zhuyin.
-n To attach sequence numbers to the output.
-z To convert the binary format back to text format in Zhuyin.
(Note: default is Pinyin)
-e If the Hanzi inside the text dictionary contains characters such as space and tab, they will be compacted to special format.
(Default)
-E If the Hanzi inside the text dictionary contains characters such as space and tab, they will NOT be compacted to special format.
-h cixingfile
To specify the Cixing definition file.
NOTE
1. The parts in [ ] are options. They may be omitted.
2. The Pinyin and Zhuyin dictionary has the same format.
3. The default conversion result of the text dictionary is in Pinyin.
13 May 1992 CDTOA(1)