Convert a tab separated file using bash Post: 302459884

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parse file into tab separated columns

Hello, I am trying to parse a file that resembles the last three groupings into something looking like the first two lines. I've fiddled with sed and awk a bit, but can't get anything to work properly. I need them separated by some delimiter. The file is some 23,000 lines of the stuff.... ...

2. UNIX for Dummies Questions & Answers

Sum up a decimal column in a tab separated text file and error handling

Hi, I have a small requirement where i need to sum up a column in a text file. Input file 66ab 000000 534385 -00000106350.00 66cd 000000 534485 -00013364511.00 66ad 000000 534485 -00000426548.00 672a 000000 534485 000000650339.82...

3. UNIX for Dummies Questions & Answers

tab-separated file to matrix conversion

hello all, i have an input file like that A A X0 A B X1 A C X2 ... A Z Xx B A X1 B B X3 .... Z A Xx Z B X4 and i want to have an output like that A B C D A X0 X1 X2 Xy B X1 X3 X4

4. UNIX for Dummies Questions & Answers

Filling a tab-separated file with known missing entries in columns

Hello all, I have a file which is tab separated like that: PHE_205_A TIP_127_W ARG_150_B MET_1150_A TIP_12_W VAL_11_B GLU_60_A TIP_130_W ARG_143_B LEU_1033_A TIP_203_W ARG_14_B SER_1092_A TIP_203_W THR_1090_A TIP_203_W SER_1092_A TIP_25_W ...

5. Shell Programming and Scripting

Problem with a tab separated file

Hi, I have created a tab separated file from the following input file. ADDRESS1 CITY STATE POSTAL COUNTRY LON LAT 32 PRINZREGENTENSTRASSE ROSENHEIM BAYERN 83022 DEU 1212182 4785699 263 VIA DANTE ALIGHIERI BARI PUGLIA 70122 ITA 1686233 4112154 30 VIA MILANO ...

6. Shell Programming and Scripting

How to replace & with and in tab separated file?

Hi, I have a tab separated. I want to replace all the "&" in 8th column of the file with "and" .I am trying with awk -F, -vOFS=\\t '{$8=($8=="&")?"and":$8}1' test> test1.txt My file is abc def ghk hjk lkm hgb jkluy acvf & bhj hihuhu fgg me mine he her go went has has & had hgf hgy ...

7. Shell Programming and Scripting

Convert comma separated file to fix length

Hi, I am converting a comma separated file to fixed field lenght and I am using that: COLUMNS="25 24 67 26 39 63 20 34 35 14 397" ( cat $indir/input_file.dat | \ $AWK -v columns="$COLUMNS" ' BEGIN { FS=","; OFS=""; split(columns, arr, " "); } { for(i=1; i<=NF;...

8. Shell Programming and Scripting

Read a tab separated file with empty column

Hi all, I'm trying to read a tab separated file and apply some functions on each column. I have an issue with empty column. Exemple: $ #cat with the sed to allow you to see my tab $ cat foo.txt| sed 's/\t/;/g' a;1;x b;;yI wanted to something like that: while read col1 col2 col3 do ...

9. Shell Programming and Scripting

Convert tab separated text to non-trivial xml. (pwsafe --> KeePassx)

I'd like to take the output of `pwsafe --exportdb > database.txt` and convert it to a KeePassX XML friendly format (feature request in pwsafe). I found flat file converter but the syntax is beyond me with this example. Solutions are welcomed. More details Here is the pwsafe --> KeePassX XML...

10. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!!

LEARN ABOUT DEBIAN

cdtoa

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)