04-03-2013
Try awk -F'[,=]' '{for (i=2;i<=NF;i+=2) {s=s+$i;} print s;}' file
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am trying to merge two large file horizontally using paste command. Every thing is working fine except for time. Its taking lot of time.
Is there any effiecient way of doing the same thing or is there anyway by which I can improve its perfomance programatically?
Thanks,
Yeheya (1 Reply)
Discussion started by: yeheyaansari
1 Replies
2. HP-UX
I have 2 files, 1.txt and 2.txt which have the following format:
1.txt
:451:1
:451:0
:451:1
and so on..
2.txt
:108:13897187
:108:90890789
:108:76476386
and so on..
I want to combine the files horizontally, I tried paste 1.txt 2.txt as well as cat but both of them are giving me... (3 Replies)
Discussion started by: anshuljain
3 Replies
3. Shell Programming and Scripting
Hi all,
I have two files -- one with 1024 lines and another with 2048 lines. I want to merge them to create another file in such way that it takes 2 lines from file with 1024 lines and 4 from 2048 lines.
I wrote a sample script and curious to see if there is a better way; i am sure there is,... (4 Replies)
Discussion started by: jakSun8
4 Replies
4. Shell Programming and Scripting
Hi Every body,
I have file which has enttries, with each 5 entries as a set of entries, I would like to read the file (line by line) and print five entries of a set vertically, the next entry should come in the next line.
Example:
cat sample_file
I am a
Unix Adminsitrator
new to shell... (6 Replies)
Discussion started by: aruveiv
6 Replies
5. Shell Programming and Scripting
Hi experts
i have a simple script that fetches the count from different servers and inserts ahead of server name like below
servera,1
serverb,25
serverc,35
what i want to do is now when i run this script next day i want that output to be next to the earlier one like below and if possible... (5 Replies)
Discussion started by: raj2989
5 Replies
6. Shell Programming and Scripting
Hello,
How to sort each row in a document with numerical values and with more than one row. Example
Input data (file1.txt):
4 6 8 1 7
2 12 9 6 10
6 1 14 5 7
and I want the the output to look like this(file2.txt):
1 4 6 7 8
2 6 9 10 12
1 5 6 7 14
I've tried
sort -n file1.txt >... (12 Replies)
Discussion started by: joseamck
12 Replies
7. UNIX for Dummies Questions & Answers
I have a 2 column file.
Column 1 is a road ID number.
Column 2 is the date that the road surface condition was inspected.
Some roads have been inspected only once, while some roads have been inspected multiple times.
I would like to re-arrange the following example list:
1001 2001_01_01... (5 Replies)
Discussion started by: kenneth.mcbride
5 Replies
8. Shell Programming and Scripting
Hi ALL
I have this data
ail,UTT,id1_0,COMBO,21,24,21,19
al,UTHAST,id1_0,COMBO,342,390,361,361
dmo,UTST,id1_0,COMBO,21,15,22,23
vne,UAST,id1_0,COMBO,345,372,390,393
I wan the sum of column 5,6,7 & 8 both horizontal and vertical.
There is one more prob the column keeps on increasing... (9 Replies)
Discussion started by: nikhil jain
9 Replies
9. Shell Programming and Scripting
Hello,
Please help create the following report.
I have a matrix
- S1 S2 S3 S4
M1 AA AA TT -
M2 AG AG AA GG
M3 GG TT - -
a first lookup table
M3 chr7 4.456
M1 chr7 28.9
M2 chr8 129.678
a second lookup table
S1 GGHBBGG/DEDD(@DCCD) (8 Replies)
Discussion started by: jianp83
8 Replies
10. Shell Programming and Scripting
Hi, I have a file like
aa bb dmns|860 dmns|756 ee ff
aa bb dmns|310 dmns|260 ee ff
aa bb dmns|110 dmns|77 ee ff
aa bb dmns|756 dmns|860 ee ff
aa bb dmns|110 dmns|77 ee ff
aa bb dmns|233 dmns|79 ee ff
aa bb dmns|79 dmns|233 ee ff
I want to sort the values in column3 and column4... (2 Replies)
Discussion started by: sammy777888
2 Replies
LEARN ABOUT DEBIAN
xlhtml
xlhtml(1) General Commands Manual xlhtml(1)
NAME
xlhtml - A program for converting Microsoft Excel Files .xls
SYNOPSIS
xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-
N] FILE
DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either html or
tab delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through
the helper scripts and one would probably rarely resort to using the commandline interface.
OPTIONS
-a aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.
-asc Ascii out of -dp and extraction data (-xc, -xp, -xr)
-csv Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)
-xml Output in XML of -dp and extraction data (-xc, -xp, -xr)
-bc Override the background color. e.g. -bc808080 for gray
-bi Use background image. e.g. -bi/home/httpd/icon/tar.gif
-c Centers the tables horizontally
-dp Dump page count and max columns and rows per page
-v Prints program version
-fw suppress formula warnings about accuracy
-m No encoding for multibyte
-nc tells it not to colorize the output.
-nh Suppress header and body tags in html output
-tc Override the text color. e.g. -tcFF0000 for red
-te Trims empty rows & columns at the edges of a worksheet
-xc Columns (separated by a dash) for extraction (zero based)
-xp Page for extraction (zero based), one page only
-xr Rows (separated by a dash) to be extracted (zero based)
An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls
The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of file:
AUTHOR
Steve Grubb, Charles N Wyble
xlhtml May 15, 2002 xlhtml(1)