I have the following text file with the each field separated by newline
Text file
Code:
P
file1-en-us_US-20170718T150157Z.json
Wed 19 Jul 2017 06:10:13 AM EDT
P
file2-en-us_US-20170718T160150Z.json
Wed 19 Jul 2017 06:10:13 AM EDT
P
file3-en-us_US-20170718T163218Z.json
Wed 19 Jul 2017 06:10:13 AM EDT
P
file4-en-us_US-20170718T170151Z.json
Wed 19 Jul 2017 06:10:13 AM EDT
Now i want to convert the above text file into html.I have researched and written the below code but the output is not in the desired format.
Desired output
Code:
Header Filename Timestamp
P file1-en-us_US-20170718T150157Z.json Wed 19 Jul 2017 06:10:13 AM EDT
P file2-en-us_US-20170718T160150Z.json Wed 19 Jul 2017 06:10:13 AM EDT
The output now is broken .
Code:
Header Filename TimeStamp
P
file1-e -us_US-20170718T150157Z.jso
Wed 19 Jul 2017 06:10:13 AM EDT
P
file2-e -us_US-20170718T160150Z.jso
Wed 19 Jul 2017 06:10:13 AM EDT
P
file3-e -us_US-20170718T163218Z.jso
Wed 19 Jul 2017 06:10:13 AM EDT
Code:
#!/bin/sh
FILES="/home/user/timestamp.txt"
for file in $FILES ; do
echo "files are " $file
html=$(echo $file | sed 's/\.txt$/\.html/i')
echo "<html>" >> $html
echo "<style type="text/css">
table, th, td {
border: 1px solid black;
}
</style>" >> $html
echo " <body>" >> $html
echo '<table>' >> $html
echo '<th>Header</th>' >> $html
echo '<th>Filename</th>' >> $html
echo '<th>TimeStamp</th>' >> $html
while IFS='\n' read -ra line ; do
echo "here"
echo "<tr>" >> $html
for i in "${line[@]}"; do
echo "<td>$i</td>" >> $html
done
echo "</tr>" >> $html
done < $file
echo '</table>'
echo " </body>" >> $html
echo "</html>" >> $html
done
Could you please help on getting the results .
Adding to that i formatted the out put in the below fashion, but still the output is displayed in the above fashion.
Code:
P file1.json Wed 19 Jul 2017 06:10:13 AM EDT
P file2.json Wed 19 Jul 2017 06:10:13 AM EDT
P file3.json Wed 19 Jul 2017 06:10:13 AM EDT
Last edited by nextStep; 07-31-2017 at 12:35 PM..
Reason: Formatting the output
i am trying to link the text files that i generated from my shell script to an html page, to that i can view them using a browser, like internet explorer.
i want to open the text files in html page when i enter a command to view the text file from the shell command.
please could anyone help... (1 Reply)
I have a html file called myfile. If I simply put "cat myfile.html" in UNIX, it shows all the html tags like <a href=r/26><img src="http://www>. But I want to extract only text part.
Same problem happens in "type" command in MS-DOS.
I know you can do it by opening it in Internet Explorer,... (4 Replies)
Hi,
I need to convert a text file formatted like this ("tshark -z conv,ip" output) to HTML:
=====================================================================================================
IPv4 Conversations
Filter:<No Filter>
| <- ... (4 Replies)
Hi,
Say there is a web page that contains just text only - that is, even the source code is just the text itself, nothing more. An example would be "http://mynasadata.larc.nasa.gov/docs/ocean_percent.txt"
Is there a UNIX command that would allow me to download this text and store it in a... (1 Reply)
Not sure the most effient way to do this.
I have figiured out how to extract columns with shell script, but not sure how to convert
This is what I have...
NEWDNS 04-Jun-2011 06:00:59.762 10.220.136.217 crl.verisign.com
This is what I need.... Change date, remove mil seconds,... (1 Reply)
I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
Hi All,
I do have a file with many lines (rows) and it is space delimited. For example: I have a file named SR345_pl.txt. If I open it in an editor, it looks like this:
adfr A2 0.9345
dtgr/2 A2 0.876
fgh/3 A2 023.76
fghe/4 A2 2345
bnhy/1 A3 3456
bhy A3 0.9876
phy A5 0.987
kdrt A5... (9 Replies)
Hi ,
I need a help in following scenario.I tried searching in google but couldn't able to find the exact answer. Sorry if i am re-posting already answered query.
While i am trying to convert into log file into csv i couldn't able to get the format which i am looking for.
I converted file... (4 Replies)
Gents
Using the script attached (raw2csv). i use to create the file .csv.. The input file is called 201.raw.
Kindly can you check if there is easy way to do it. The script works fine but takes a lot time to process
Thanks for your help (8 Replies)