Help with awk and html

Tags

shell scripts

Top Forums Shell Programming and Scripting Help with awk and html

Prev Next

01-20-2017

Registered User

27, 0

Join Date: Dec 2016

Last Activity: 21 April 2017, 1:01 PM EDT

Posts: 27

Thanks Given: 6

Thanked 0 Times in 0 Posts

Help with awk and html

Hi

i have a file say test with the following output

Code:

server    share-name                   path                                              acl                                                                           
---------- ---------------------------- ------------------------------------------------- -----------------------------------------------------------------------------------------------------------------------------------
TEST_SERVER TEST_SHARE_PATH /TEST/TESTSHAREPATH "test\testuser / Read","test\testuser1_R / Read","test\testuser2_RW / Change"

Need some help in achieve the attached output and send it via sendmail to outlook with html headers.

Expected output i have attached.

Kindly help

test.xls (44.5 KB)

venkitesh

View Public Profile for venkitesh

Find all posts by venkitesh

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk to extract value after keyword in html

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"> ...

2. UNIX for Beginners Questions & Answers

Html output with awk/sendmail

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...

3. UNIX for Beginners Questions & Answers

awk HTML Conditional Formating

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_ ...

4. Shell Programming and Scripting

Extract text from html using perl or awk

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. Shell Programming and Scripting

Awk/sed HTML extract

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...

6. Shell Programming and Scripting

awk to parse html file

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> ...

7. Shell Programming and Scripting

awk help for HTML

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...

8. Shell Programming and Scripting

Need help shell+awk+html

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'/ &&...

9. Shell Programming and Scripting

awk to create two HTML Tables

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 : ...

10. Shell Programming and Scripting

html formatting using awk

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...

Shell Programming and Scripting