01-20-2017
An .xls (= binary) file with HTML headers? "sendmail to outlook"? Hmmmm...
I guess at least a sample output is definitely needed here!
Your input sample seems to have spaces as field separators as well as interspersed in field 4. Did you search for similar cases and their solutions in these fora? A small awk script might create a .csv file for you, to be easily read into EXCEL if need be.
Any attempts / ideas / thoughts from your side? Any preferred tools?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi I have a file as given below:
<table border=1>
<TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR>
<TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR>
<TR><TD><CENTER>admin_export.sh</CENTER></TD><TD><CENTER>Locally... (1 Reply)
Discussion started by: sudvishw
1 Replies
2. Shell Programming and Scripting
I am working on awk script to generate an HTML format output. With input file as below I am able to generate a HTML file however I want to saperate spare devices in a different table than rest of the devices and which has only Bunch ID, RAW Size and "Bunch Spare" status columns.
INPUT File :
... (2 Replies)
Discussion started by: dynamax
2 Replies
3. Shell Programming and Scripting
Hi,
Can someone help me how to add header cell in html table if i use the script posted below?
I use shell script to search in files and format output into html table.
/bin/zcat /CDR/cdr_TC/calllogs*_*_$FORM_data*.gz | sed 's//;/g' | awk -F";" '{if($1~/'$FORM_msgid'/ &&... (8 Replies)
Discussion started by: vasil
8 Replies
4. Shell Programming and Scripting
Hi all,
I have a file as below input.csv
NAME,EMPNO,PHNO
kkk,1234,0000
nnn,456,8765
hhh,888,555
hhy,222,567
i want to convert this into HTML table im using this
awk -F"," 'BEGIN{print "<table border=1>" { print "<tr>";for(i=1;i<=NF;i++)print "<td><b><font face=\"verdana\"><font... (1 Reply)
Discussion started by: zozoo
1 Replies
5. Shell Programming and Scripting
Is it possible in awk to parse a webpage (EDAR Gene Sequencing - Genetic Testing Company | The DNA Diagnostic Experts | GeneDx), the source code is attached.
<title> EDAR Gene Sequencing
<dt>Test Code:</dt>
<dd>156 </dd>
<dt>Turnaround Time:</dt>
<dd>6-8 weeks </dd>
... (4 Replies)
Discussion started by: cmccabe
4 Replies
6. Shell Programming and Scripting
I'm extracting text between table tags in HTML
<th><a href="/wiki/Buick_LeSabre" title="Buick LeSabre">Buick LeSabre</a></th>
using this:
awk -F "</*th>" '/<\/*th>/ {print $2}' auto2 > auto3
then this (text between a href):
sed -e 's/\(<*>\)//g' auto3 > auto4
How to shorten this into one... (8 Replies)
Discussion started by: p1ne
8 Replies
7. Shell Programming and Scripting
I am trying to extract text after keywords fron an html file. The keywords are reportLink":, "barcodedSamples": {", "barcodedSamples": {". Both the perl and awk run but the output is just the entire index.html not the desired output. Also for the reportLink": only the text after the second / until... (5 Replies)
Discussion started by: cmccabe
5 Replies
8. UNIX for Beginners Questions & Answers
I am receiving the below output in text format. The output is converted to HTML table using the code mentioned below
output in text
LogDate DayOfWeek/Hours _0_ _1_ _2_ _3_ _4_ _5_ _6_ _7_ _8_ _9_ _10_ _11_ _12_ _13_ _14_ _15_ _16_ ... (3 Replies)
Discussion started by: Dumpi16
3 Replies
9. UNIX for Beginners Questions & Answers
Hello All,
I inherited maintenance of a script that uses awk on an input file (space delimited) and formats it into an html table and send out using sendmail. I know how to manipulate the print statements to add columns and rows, however that is the extent of my html knowlege. I've searched... (5 Replies)
Discussion started by: Big-J
5 Replies
10. UNIX for Beginners Questions & Answers
Using awk to extract value after a keyword in an html, and store in ts. The awk does execute but ts is empty. I use the tag as a delimiter and the keyword as a pattern, but there probably is a better way. Thank you :).
file
<html><head><title>xxxxxx xxxxx</title><style type="text/css">
... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT DEBIAN
srconv
SRCONV(1) The Canonical Csound Reference SRCONV(1)
NAME
srconv - Converts the sample rate of an audio file. .
DESCRIPTION
Converts the sample rate of an audio file at sample rate Rin to a sample rate of Rout. Optionally the ratio (Rin / Rout) may be linearly
time-varying according to a set of (time, ratio) pairs in an auxiliary file.
SYNTAX
srconv [flags] infile
INITIALIZATION
Flags:
o -P num = pitch transposition ratio (srate / r) [don't specify both P and r]
o -P num = pitch transposition ratio (srate / r) [don't specify both P and r]
o -Q num =quality factor (1, 2, 3, or 4: default = 2)
o -i filnam = auxiliary breakpoints file (no breakpoint by default. i.e. No ratio change)
o -r num = output sample rate (must be specified)
o -o fnam = sound output filename
o -A = create an AIFF format output soundfile
o -J = create an IRCAM format output soundfile
o -W = create a WAV format output soundfile
o -h = no header on output soundfile
o -c = 8-bit signed_char sound samples
o -a = alaw sound samples
o -8 = 8-bit unsigned_char sound samples
o -u = ulaw sound samples
o -s = short_int sound samples
o -l = long_int sound samples
o -f = float sound samples
o -r N = orchestra srate override
o -K = Do not generate PEAK chunks
o -R = continually rewrite header while writing soundfile (WAV/AIFF)
o -H# = print a heartbeat style 1, 2 or 3 at each soundfile write
o -N = notify (ring the bell) when score or miditrack is done
o -- fnam = log output to file
This program performs arbitrary sample-rate conversion with high fidelity. The method is to step through the input at the desired sampling
increment, and to compute the output points as appropriately weighted averages of the surrounding input points. There are two cases to
consider:
1. sample rates are in a small-integer ratio - weights are obtained from table.
2. sample rates are in a large-integer ratio - weights are linearly interpolated from table.
Calculate increment: if decimating, then window is impulse response of low-pass filter with cutoff frequency at half of output sample rate;
if interpolating, then window is impulse response of lowpass filter with cutoff frequency at half of input sample rate.
CREDITS
Author: Mark Dolson
August 26, 1989
Author: John ffitch
December 30, 2000
AUTHORS
Barry Vercoe
MIT Media Lab
Author.
Dan Ellis
MIT Media Lab,
Cambridge
Massachussetts
Author.
COPYRIGHT
5.10 08/01/2011 SRCONV(1)