Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Shell script, For loop output to excel as columns Post 303038925 by srilaxman on Tuesday 17th of September 2019 07:59:05 AM
Old 09-17-2019
Great ! Both the code worked. Thankyou so much. Can you also help me with the code to append the output the as a row to the excel everytime when this script gets executed ?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sed subsitution on loop output in shell script

I have a forloop which checks a log for a set of 6 static IP addresses and each IP found is logged to a file which is then mailed to me. After the forloop I always have a text file that may contain up to 6 IP addresses or may contain 0. What I want to do is substitute the IP addresses (if any)... (2 Replies)
Discussion started by: Moxy
2 Replies

2. Shell Programming and Scripting

How to give a variable output name in a shell script inside a for loop

Hi all I run my program prog.c in the following way : $ ./prog 1 > output.txt where 1 is a user defined initial value used by the program. But now I want to run it for many a thousand initial values, 1-1000, and store all the outputs in different files. Like $ ./prog 1... (1 Reply)
Discussion started by: alice06
1 Replies

3. Shell Programming and Scripting

Script to parse TOP output for Excel

I'd like to parse TOP output file containing data like the below, and then be able to import the parsed file in to Excel where I can easily generate graphs. Ideally, the output would have a single column for each value in the output. Any thoughts on how to get started with this, or a better... (3 Replies)
Discussion started by: NoMasVentanas
3 Replies

4. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

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

5. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting... (4 Replies)
Discussion started by: bornali.p
4 Replies

6. Shell Programming and Scripting

Excel from shell script

Is it possible to generate excel sheet from a shell script and rename the worksheet..? Thanks for your answer (1 Reply)
Discussion started by: Anu_1
1 Replies

7. Shell Programming and Scripting

Shell do loop to compare two columns (duplicates)

Hello, I have a single text file with three columns like: 2 1 10 3 6 11 4 4 12 5 5 13 6 8 14 I was wondering how I can run a shell script to (do loop) to read the first point in the first column , compare it with all the points in the second column and if they are the same,... (12 Replies)
Discussion started by: Paul Moghadam
12 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

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

9. Shell Programming and Scripting

Perl script to accept specific columns from excel

Hi All, I have below perl script which writes xml from .xls file. Now i want to add below two conditions in this script : 1. to check if the the input .xls file has ony two columns , if more tahn two columns then script should pop up an error. 2. If there are two columns , then first column... (4 Replies)
Discussion started by: omkar.jadhav
4 Replies

10. UNIX for Beginners Questions & Answers

For loop output to excel file

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... (1 Reply)
Discussion started by: srilaxman
1 Replies
ns_adp_registertag(3aolserver)				    AOLserver Built-In Commands 			    ns_adp_registertag(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME
ns_adp_registeradp, ns_adp_registerproc, ns_adp_registerscript, ns_adp_registertag, ns_register_adptag - ADP registered tags SYNOPSIS
ns_adp_registeradp tag ?endtag? adp ns_adp_registerproc tag ?endtag? proc ns_adp_registerscript tag ?endtag? script ns_adp_registertag tag ?endtag? adp ns_register_adptag tag ?endtag? script _________________________________________________________________ DESCRIPTION
These commands enable definition of HTML tags within an ADP file which are expanded and evaluated by the server before returning output to the client. Tags are defined as eitehr a single tag with options, e.g., <mytag a=b c=d> or as an opening/closing tag pair, e.g., <mytag> text </mytag>. This approach is an alternative to direct calls via the <% script %> syntax as described in the ns_adp man page. ns_adp_registeradp tag ?endtag? adp ns_adp_registertag tag ?endtag? adp These commands are identical and register an ADP code fragment to be invoked when the specified tag is encountered while parsing an ADP. The tag argument specifies the tag that will trigger invocation of the ADP fragment, which is specified by the adp argument. If the endtag argument is specified, then the ADP fragment will be invoked with two arguments: The first will be the enclosed con- tent, and the second will be the name of an ns_set with any attributes specified in the tag. If no endtag argument is specified, the ADP fragment will only be passed the name of the ns_set. The arguments may be retrieved using ns_adp_bindargs or ns_adp_argc and ns_adp_argv. When the ADP fragment is invoked, its result is inserted in the output instead of the tag (or, if the endtag was specified, in place of the tag, end tag, and the enclosed content). Note: Care must be taken when using this function from inside an ADP, because the adpstring is likely to contain script delimiters (<% ... %>) which will prematurely terminate script fragments. It is probably easier to restrict use of this function to .tcl files. ns_adp_registerproc tag ?endtag? proc This commands register a Tcl procedure to be evaluated when the given tag is encountered. The tag argument specifies the tag that will trigger a call to the procedure specified by the proc argument. The procedure will be called with a variable number of arguments, one for each of the attributes provided in the tag. If the endtag argument is specified, the procedure will also receive a final argument with the contents of the text enclosed between the tags. No evaluation of the content will be performed, it will be passed as a single text block. When the procedure is invoked, its result is inserted in the output instead of the tag (or, if the endtag was specified, in place of the tag, end tag, and the enclosed content). ns_adp_registerscript tag ?endtag? script ns_register_adptag tag ?endtag? script These commands are identical and register a Tcl script to be evaluated when the given tag is encountered. The tag argument speci- fies the tag that will trigger evaluation of the script specified by the script argument. If the endtag argument is specified, then the script will be modified with two arguments appended: The first will be the enclosed content, and the second will be the name of an ns_set with any attributes specified in the tag. If no endtag argument is specified, the script will be modified with just the name of the ns_set appended. When the script is evaluated, its result is inserted in the output instead of the tag (or, if the endtag was specified, in place of the tag, end tag, and the enclosed content). EXAMPLES
The following is a simple way of handling conditional content in ADPs: proc remember {input tagset} { global _adp_memory set tagname [ns_set iget $tagset name] if {[string match "" $tagname]} { set _adp_memory($tagname) $input return "" } else { return $input } } proc recall {name} { global _adp_memory if {[info exists _adp_memory($name)]} { set parsecommand [list ns_adp_parse -string] lappend parsecommand $_adp_memory($name) ns_puts -nonewline [uplevel $parsecommand] } else { ns_log Error "[ns_adp_argv 0]: Unable to recall } } If the preceding Tcl has been executed (perhaps during server startup), then the following ADP fragment displays the results of a database query in a table, or shows "No rows in result." if there are no rows: <% set rows {} set db [ns_db gethandle] ns_db exec "select somecolumn from sometable" set row [ns_db bindargs $db] while {[ns_db getrow $db $row] > 0} { lappend rows [ns_set get $row "somecolumn"] } ns_db releasehandle $db %> <remember name="hasrows_header"> <table> </remember> <remember name="hasrows_rows"> <tr> <td><%=$column%></td> </tr> </remember> <remember name="hasrows_footer"> </table> </remember> No rows in result. <remember name="norows"> <% if {[llength $rows] > 0} { recall "hasrows_header" foreach row $rows { set column $row recall "hasrows_rows" } recall "hasrows_footer" } else { recall "norows" } %> The following example demonstrates the use of ns_adp_registertag: ns_adp_registertag printdate { The current date is: <%=[ns_httptime [ns_time]]%> } Once defined, typically in a startup script, you could simple include the "<printdate>" tag to append the text with current date into the output buffer. SEE ALSO
ns_adp(1), ns_adp_eval(n), ns_adp_safeeval(n), ns_adp_include(n) KEYWORDS
ADP, dynamic pages, registered tag AOLserver 4.0 ns_adp_registertag(3aolserver)
All times are GMT -4. The time now is 11:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy