|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Convert a tab separated file using bash
Post 302459930 by TheTransporter on Tuesday 5th of October 2010 03:48:34 PM
10-05-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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....
... (9 Replies)
Discussion started by: dkozel
9 Replies
2. UNIX for Dummies Questions & Answers
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... (5 Replies)
Discussion started by: pssandeep
5 Replies
3. UNIX for Dummies Questions & Answers
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 Replies)
Discussion started by: TheTransporter
4 Replies
4. UNIX for Dummies Questions & Answers
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 ... (6 Replies)
Discussion started by: TheTransporter
6 Replies
5. Shell Programming and Scripting
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 ... (1 Reply)
Discussion started by: ramky79
1 Replies
6. Shell Programming and Scripting
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
... (1 Reply)
Discussion started by: jagdishrout
1 Replies
7. Shell Programming and Scripting
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;... (5 Replies)
Discussion started by: apenkov
5 Replies
8. Shell Programming and Scripting
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
... (4 Replies)
Discussion started by: maturix
4 Replies
9. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: graysky
2 Replies
10. UNIX for Beginners Questions & Answers
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!! (4 Replies)
Discussion started by: frisso
4 Replies
LEARN ABOUT DEBIAN
filep
mailp(1) User Commands mailp(1) NAME
mailp, digestp, filep, newsp, filofaxp, franklinp, timemanp, timesysp - frontends to the mp Text to PDL (Printer Description Language) pretty print filter SYNOPSIS
mailp [options] filename... newsp [options] filename... digestp [options] filename... filep [options] filename... filofaxp [options] filename... franklinp [options] filename... timemanp [options] filename... timesysp [options] filename... DESCRIPTION
The mailp utility is a frontend to the mp(1) program. It uses different names to provide various mp options: mailp Prints out mail messages. newsp Prints out USENET news articles. digestp Prints out USENET digest files. filep Prints out ordinary ASCII files. filofaxp Prints out in Filofax personal organiser format. franklinp Prints out in Franklin Planner personal organiser format. timemanp Prints out in Time Manager personal organiser format. timesysp Prints out in Time/System International personal organiser format. mailp and the associated programs read each filename in sequence and generate a prettified version of the contents. If no filename argu- ments are provided, mailp reads the standard input. mailp works in two ways. With the -D option, it will work as an X print server client to produce the PDL of the target printer and spool it. With the -d or -P option, it will generate and spool PostScripttm output. OPTIONS
The following options are supported: -d printer Sends output to the named printer. Otherwise, sends output to the printer named in the PRINTER environment variable. -D Generates the PDL for the target printer and spools it to the printer. -F Instead of printing who the mail article is for, the top header will contain who the mail article is from. This is a useful option for people with their own personal printer. -h Banner printing is disabled. Most of the information that typically appears on the banner sheet is output in the mp ban- ners. -l Formats output in landscape mode. Two pages of text will be printed per sheet of paper. -P printer Same as -d option. -s subject Uses subject as the new subject for the printout. If you are printing ordinary ASCII files which have been specified on the command line, the subject will default to the name of each of these files. OPERANDS
The following operand is supported: filename The name of the file to be read. ENVIRONMENT VARIABLES
If none of the -d, -D, or -P options is used, mailp uses the PRINTER environment variable to determine the printer to which the output from the mp(1)program is sent. If the PRINTER variable is not found, the default destination is the PostScripttm printer. EXIT STATUS
The following exit values are returned: 0 Successful completion. 1 An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWmp | +-----------------------------+-----------------------------+ SEE ALSO
mp(1), attributes(5) NOTES
The -P option, which spools the PDL directly to the target printer in mp(1), produces PostScripttm when used in mailp so as to be backward compatible. SunOS 5.10 30 Oct 2000 mailp(1)