Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Converting text file to html page
Top Forums UNIX for Beginners Questions & Answers Converting text file to html page Post 303001722 by nextStep on Thursday 10th of August 2017 12:28:10 AM
Old 08-10-2017
HTML results in headers
Hi Corona688,

The code you gave to me was extremely useful .Now when i incorporated in the main script all the results are coming under the "Header" cell
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-20170718T150157Z.json Wed 19 Jul 2017 06:10:13 AM EDT
P	file3-en-us_US-20170718T150157Z.json Wed 19 Jul 2017 06:10:13 AM EDT

There is no change in the source file
Code:
P	file1-en-us_US-20170718T150157Z.json	Wed 19 Jul 2017 06:10:13 AM EDT
P	file2-en-us_US-20170718T150157Z.json	Wed 19 Jul 2017 06:10:13 AM EDT
P	file3-en-us_US-20170718T150157Z.json	Wed 19 Jul 2017 06:10:13 AM EDT

I have few functions above the given function as below.Could you please advise what needs to be modified to get the records in each Cell like earlier.

Code:
fn_parsepccanfrenchJson()
{
#echo "inside parse3"
arr=( $(find /home/aunnikrishnan/pccanfrench/json/ -type f -name "*.json" | cut -d '/' -f6-))
len=${#arr[@]}
IFS=! timearr=( $(find /home/aunnikrishnan/pccanfrench/json/ -type f -name "*.json" -printf '%Tc!' ) )
timeArray=(`echo ${timearr}`)
for ((i=0; i<$len; i++))
do
        appVersion=$(cat "/home/aunnikrishnan/pccanfrench/json/${arr[i]}"|jq '.' | grep "groupType" | awk -F ': ' '{print $2}' | sed 's/\"//g' | sed 's/ //g' | sed 's/,//')
        appArr=(`echo ${appVersion}`)

        UnixShell=("$appArr" "${arr[i]}" "$timeArray" )
        printf '%s\t%s\t%s\t\n' "${UnixShell[@]}"  >> pccanfrench.txt
done
}
#fn_parsepccanfrenchJson

#ILES="pcusaenglish.txt"
#FILES="timestamp.txt"

fn_html()
{
FILES="timestamp.txt"
echo "<html>
<style type='text/css'>
            table, th, td {
            border: 1px solid black;
            }
</style>
<body>
<table><tr><th>Header:</th><th>Filename:</th><th>TimeStamp:</th></tr>"

for FILE in $FILES
do
        while read H F D
        do
                printf "<tr>"
                printf "<td>%s</td>" "$H" "$F" "$D"
                printf "</tr>"
        done <$FILE
done

printf "</table></body></html>\n"
}
fn_html

[/QUOTE][/QUOTE]
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

linking unix generated text file to html page

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)
Discussion started by: alexd
1 Replies

2. UNIX for Dummies Questions & Answers

Converting HTML to CSV

Hi, I need to convert a relatively large html file (1.5megs) into CSV under Unix. How would I be able to do this? Much thanks. (3 Replies)
Discussion started by: Jexel
3 Replies

3. UNIX for Dummies Questions & Answers

How do I extract text only from html file without HTML tag

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)
Discussion started by: los111
4 Replies

4. Shell Programming and Scripting

Converting a text file to HTML

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)
Discussion started by: ph0enix
4 Replies

5. UNIX for Dummies Questions & Answers

Possible to download web page's text to a file?

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)
Discussion started by: Breanne
1 Replies

6. Shell Programming and Scripting

Converting columns of a text file.

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)
Discussion started by: mrlayance
1 Replies

7. UNIX for Dummies Questions & Answers

Converting a text file with irregular spacing into a space delimited text file?

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)
Discussion started by: evelibertine
5 Replies

8. Shell Programming and Scripting

Converting text file in a matrix

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)
Discussion started by: Lucky Ali
9 Replies

9. Shell Programming and Scripting

Format problem while converting text file to csv

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)
Discussion started by: varmas424
4 Replies

10. Shell Programming and Scripting

Converting data for text file to csv

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)
Discussion started by: jiam912
8 Replies

LEARN ABOUT OSX

json_write

json::write(n)							       JSON							    json::write(n)

__________________________________________________________________________________________________________________________________________________

NAME

       json::write - JSON generation

SYNOPSIS

       package require Tcl  8.5

       package require json::write  ?1?

       ::json::write indented

       ::json::write indented flag

       ::json::write aligned

       ::json::write aligned flag

       ::json::write string s

       ::json::write array arg...

       ::json::write object key value...

_________________________________________________________________

DESCRIPTION

       The  json::write package provides a simple Tcl-only library for generation of text in the JSON http://www.json.org/ data exchange format as
       specified in RFC 4627 http://www.ietf.org/rfc/rfc4627.txt.

COMMANDS

       ::json::write indented
	      This method returns the current state of the indentation setting.

       ::json::write indented flag
	      This and the method aligned configure the layout of the JSON generated by the package.

	      If this flag is set (default) the package will break the generated JSON code across lines and  indent  it  according  to	its  inner
	      structure, with each key of an object on a separate line.

	      If this flag is not set, the whole JSON object will be written on a single line, with minimum spacing between all elements.

       ::json::write aligned
	      This method returns the current state of the alignment setting.

       ::json::write aligned flag
	      This and the method indented configure the layout of the JSON generated by the package.

	      If  this flag is set (default) the package ensures that the values for the keys in an object are vertically aligned with each other,
	      for a nice table effect. To make this work this also implies that indented is set as well.

	      If this flag is not set, the output is formatted as per the value of indented, without trying to align the values for object keys.

       ::json::write string s
	      This method takes the string s and returns it properly quoted for JSON as its result.

       ::json::write array arg...
	      This method takes a series of JSON formatted arguments and returns them as a properly formatted JSON array as its result.

       ::json::write object key value...
	      This method takes a series of key/value arguments, the values already formatted for JSON, and returns them as a  properly  formatted
	      JSON object as its result, with the keys formatted as JSON strings.

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category json of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       data exchange, exchange format, javascript, json

CATEGORY

       CGI programming

COPYRIGHT

       Copyright (c) 2009 Andreas Kupries <andreas_kupries@sourceforge.net>

json									1.0							    json::write(n)
All times are GMT -4. The time now is 12:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy