In the meantime, you might want to try this... I'd like to hear from you if it works in general, even if you prefer the perl thingy
Code:
#!/bin/bash
header=(); values=(); start=0
while IFS=":" read var val
do
if [[ "$var" = "{" && "$start" = "0" ]]; then # "new" set detected
start=1
continue
elif [[ "$var" = "" ]]; then
echo
continue
elif [[ "$var" = "}" ]]; then # end of a set
printf "%s\n%s\n" "${header[@]}" "${values[@]}"
start=0; header=(); values=()
continue
else # process stuff within a set
var="${var//\"/}"; var="$(echo $var)"
[[ "${#header[@]}" -eq "0" ]] && header=("$var") || header=("${header[@]}","$var")
val="${val# }"; val="${val%,}"
[[ "${#values[@]}" -eq "0" ]] && values=("$val") || values=("${values[@]}","$val")
fi
done <inputfile
Hi,
I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this?
Regards,
Garric (4 Replies)
Hi,
Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent.
E.g : username empid
------------------------
sri 123
to
username,empid
sri,123
Thanks,
Hema:confused: (2 Replies)
I've been trying to figure this out for a while but I'm completely stumped. I have files with data in rows and I need to convert the data to columns. Each record contains four rows with a "field name: value" pair. I would like to convert it to four columns with the field names as column headers... (5 Replies)
Hi All,
I was wondering how I can convert each line in an input file where fields are separated by variable width spaces into a CSV file. Below is the scenario what I am looking for.
My Input data in inputfile.txt
19 15657 15685 Sr2dReader 107.88 105.51... (4 Replies)
Hi All,
I need to convert an exel spreadsheet into a SAS dataset,
and the following format change is needed. Please help, this is too complex
for a biologist.
Let me describe the input.
1st row is generation.1st column in keyword 'generation', starting 2nd column there are 5... (9 Replies)
I have a file that contains 2 columns tag,pos
cat input_file
tag pos
atg 10
ata 16
agt 15
agg 19
atg 17
agg 14
I have used following command to sort the file based on second column
sort -k 2 input_file
tag pos
atg 10
agg 14
agt 15
ata 16
agg 19
atg 17 (2 Replies)
i have a file (csv or txt or anything which has 4 columns (id,name,number,location) and it contains data. i want to convert the data of specific columns like name to ooooo and number to 88888 matching the field length of that columns.
for example
if name column has
anthony which is 7, it should... (2 Replies)
Hi All,
I have a data file and need to extract and convert it into csv format:
1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this.
2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)
Discussion started by: abhi_123
9 Replies
LEARN ABOUT DEBIAN
cgi::formbuilder::template::cgi_ssi
CGI::FormBuilder::Template::CGI_SSI(3pm) User Contributed Perl Documentation CGI::FormBuilder::Template::CGI_SSI(3pm)NAME
CGI::FormBuilder::Template::CGI_SSI - FormBuilder interface to CGI::SSI
SYNOPSIS
my $form = CGI::FormBuilder->new(
fields => @fields,
template => {
type => 'CGI_SSI',
file => "template.html",
},
);
DESCRIPTION
This engine adapts FormBuilder to use "CGI::SSI".
You can specify any options which "CGI::SSI->new" accepts by using a hashref:
my $form = CGI::FormBuilder->new(
fields => @fields,
template => {
type => 'CGI::SSI',
file => 'form.shtml',
sizefmt => 'abbrev'
}
);
In addition to CGI::SSI new arguments, you can also specify "file", "virtual", or "string" argument.
The following methods are provided (usually only used internally):
engine
Returns a reference to the "CGI::SSI" object
prepare
Returns a hash of all the fields ready to be rendered.
render
Uses the prepared hash and expands the template, returning a string of HTML.
TEMPLATES
In your template, each of the form fields will correspond directly to a "<!--#echo -->" of the same name prefixed with "field-" in the
template. So, if you defined a field called "email", then you would setup a variable called "<!--#echo var="field-email" -->" in your
template.
In addition, there are a couple special fields:
<!--#echo var="js-head" --> - JavaScript to stick in <head>
<!--#echo var="form-title" --> - The <title> of the HTML form
<!--#echo var="form-start" --> - Opening <form> tag and internal fields
<!--#echo var="form-submit" --> - The submit button(s)
<!--#echo var="form-reset" --> - The reset button
<!--#echo var="form-end" --> - Just the closing </form> tag
Let's look at an example "form.html" template we could use:
<html>
<head>
<title>User Information</title>
<!--#echo var="js-head" --><!-- this holds the JavaScript code -->
</head>
<!--#echo var="form-start" --><!-- this holds the initial form tag -->
<h3>User Information</h3>
Please fill out the following information:
<!-- each of these <!--#echo -->'s corresponds to a field -->
<p>Your full name: <!--#echo var="field-name" -->
<p>Your email address: <!--#echo var="field-email" -->
<p>Choose a password: <!--#echo var="field-password" -->
<p>Please confirm it: <!--#echo var="field-confirm_password-->
<p>Your home zipcode: <!--#echo var="field-zipcode -->
<p>
<!--#echo var="form-submit" --><!-- this holds the form submit button -->
</form><!-- can also use "tmpl_var form-end", same thing -->
As you see, you get a "<!--#echo -->" for each for field you define.
However, you may want even more control. That is, maybe you want to specify every nitty-gritty detail of your input fields, and just want
this module to take care of the statefulness of the values. This is no problem, since this module also provides several other "<tmpl_var>"
tags as well:
<!--#echo var="value-[field] --> - The value of a given field
<!--#echo var="label-[field] --> - The human-readable label
<!--#echo var="comment-[field] --> - Any optional comment
<!--#echo var="error-[field] --> - Error text if validation fails
<!--#echo var="required-[field] --> - See if the field is required
This means you could say something like this in your template:
<!--#echo var="label-email" -->:
<input type="text" name="email" value="<!--#echo var="value-email" -->">
<font size="-1"><i><!--#echo var="error-email" --></i></font>
And FormBuilder would take care of the value stickiness for you, while you have control over the specifics of the "<input>" tag. A sample
expansion may create HTML like the following:
Email:
<input type="text" name="email" value="nate@wiger.org">
<font size="-1"><i>You must enter a valid value</i></font>
Note, though, that this will only get the first value in the case of a multi-value parameter (for example, a multi-select list). Multiple
values (loops) in "CGI_SSI" are not yet implemented.
For more information on templates, see HTML::Template.
SEE ALSO
CGI::FormBuilder, CGI::FormBuilder::Template, HTML::Template
REVISION
$Id: HTML.pm 97 2007-02-06 17:10:39Z nwiger $
AUTHOR
Copyright (c) Nate Wiger <http://nateware.com>. All Rights Reserved.
This module is free software; you may copy this under the terms of the GNU General Public License, or the Artistic License, copies of which
should have accompanied your Perl kit.
perl v5.14.2 2011-09-16 CGI::FormBuilder::Template::CGI_SSI(3pm)
06-07-2016
