12-13-2012
Thanks itkamaraj,
But as I wanted to know if there was a way of doing the formatting using shell script itself rather than manually as described in the link you posted.
The output of my script is directly fed to an excel sheet which gets created each time it is run. We need to ensure that before our data is fed, the excel sheet is already in text mode.We cannot afford to review the data format in excel,as the excel sheet is directly supposed to be attached in an email and sent off.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am looking for a way to format the output of this string into comma separated values (.csv) so I can import into excel.
Also I want to remove any white space generated by the commands, particularly the dmidecode as the output has lots of space in front of Serial Number.
#!/bin/bash
for... (8 Replies)
Discussion started by: Adrnalnrsh
8 Replies
2. Shell Programming and Scripting
Dear readers,
I have a script that counts the number of files in particular directories in my home location and displays the output. Now I have 13 directories in my home location. I am getting the output as :
Avishek_dir 13
Kunal_dir 17
Shantanu_dir 18
Arup_dir 12
Pranabesh_dir 19
.
.... (7 Replies)
Discussion started by: avishek007
7 Replies
3. Shell Programming and Scripting
Hi All,
I'm finding it difficult to format the query output that was returned in a shell script.
Actually i have one shell script which does some DB stuff and depending on the result it will do some more tasks. My question here is to format the query output returned by mysql.
Intitally my... (5 Replies)
Discussion started by: RSC1985
5 Replies
4. Shell Programming and Scripting
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies
5. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
6. Shell Programming and Scripting
I'm looking for a way to neaten up the out put of an ldapquery. I might get one, none, or several returns for each query; and each query consists of multiple lines. And while each return will contain the same types of info, it might be in a different order, like:
uniq: 1
ip: 192.168.2.3... (3 Replies)
Discussion started by: jnojr
3 Replies
7. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
8. Shell Programming and Scripting
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies
9. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
10. UNIX for Beginners Questions & Answers
Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help?
The output which I get
Server1 : count... (14 Replies)
Discussion started by: srilaxman
14 Replies
LEARN ABOUT REDHAT
frontend-spec
FRONTEND-SPEC(7) FRONTEND-SPEC(7)
NAME
frontend-spec - interface between jw and its frontends
DESCRIPTION
jw(1) calls frontends like frontends/docbook to get the informations specific to a given input format. The frontend knows which information
to return from the first command line parameter. It gets all necessary data via environment variables ready to use.
This document describes that command line parameter and those environment variables.
The frontend should return 0 if there weren't any problem, and return a positive value otherwise.
VARIABLES
$1
The command line parameter, specifying which information to return. It can take the following values:
centralized-catalog
The frontend must return the DTD-specific centralized catalog name. Centralized catalogs normally reside in /etc/sgml and
provide the location of all the catalog files useful for handling this input type (the catalog for the DTD, the catalog for
the stylesheets, the catalog for the entities, ...)
style-sheet
The frontend must return the filename of the style sheet to be used for this document type and with the chosen backend.
SGML_CATALOGS_DIR
The directory where the centralized catalogs reside. It is normally /etc/sgml.
(This variable is valid only while determining the centralized catalog to use.)
SGML_BASE_DIR
The base directory of the SGML system. It is normally /usr/share/sgml.
(This variable is valid only while determining the style sheet to use.)
SGML_FILE
The name of the file to convert.
(This variable is valid only while determining the centralized catalog to use.)
SGML_TYPE
The type of the backend to use, whether it produces output files to be displayed online or to be printed out. It can take the value
html or print.
(This variable is valid only while determining the style sheet to use).
SGML_STYLESHEETS
The desired custom stylesheet type, either none or default. If none, the frontend must return the file name of the style sheet pro-
vided by the system beneath the docbook-utils. If default, the frontend must return the custom stylesheet provided by the docbook-
utils.
(This variable is valid only while determining the style sheet to use).
SGML_XML
The metalanguage of the file to convert, either sgml or xml.
(This variable is valid only while determining the centralized catalog to use).
FILES
SEE ALSO
backend-spec(7)
AUTHORS
Jochem Huhmann <joh@revier.com>
05 February 2003 FRONTEND-SPEC(7)