01-28-2008
add double quotes around the numeric field so it is translated as a text value by Excel.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies
2. Shell Programming and Scripting
I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ?
I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
Discussion started by: Sriranga
4 Replies
3. Post Here to Contact Site Administrators and Moderators
Hi All,
There are list of 4-5 .csv files which has 12 columns.In some cases one of the record is split into 2 records. What needs to be done is this split record has to be auto corrected and placed in the csv file.
Eg:
Let us consider sample.csv file and in normal conditions the file... (1 Reply)
Discussion started by: karthik_ak
1 Replies
4. Shell Programming and Scripting
Hi All,
There are list of 4-5 .csv files which has 12 columns.In some cases one of the record is split into 2 records. What needs to be done is this split record has to be auto corrected and placed in the csv file.
Eg:
Let us consider sample.csv file and in normal conditions the file would... (40 Replies)
Discussion started by: karthik_ak
40 Replies
5. UNIX for Dummies Questions & Answers
Hi guys - I have a file and output like this below:
File: myfile.dat
File has content like this: ABCD, 34, 456, 2324
I would like excel to have this:
Name (ABCD) Quantity (34), Type (456), Status (2324)
(Name, Quantity, Type and Status are columns)
I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies
6. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
7. Shell Programming and Scripting
Hello Unix Shell Script Experts,
I have a script that would mask the columns in .csv file or .txt file.
First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder.
Two parameters are passed
... (5 Replies)
Discussion started by: Mahesh G
5 Replies
8. UNIX for Beginners Questions & Answers
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
9. Programming
Hi Experts,
I am writing a python script to grep string from file and display output in csv file as in attached screenshot
https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view
Input file(result_EPFT_config_device)
Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies
10. UNIX for Beginners Questions & Answers
Hi All ,
I would require your help to generate one output file after post processing of one CSV file as stated below
This file is just a small cut from a big file . Big file is having 20000 lines
PATTERN,pat0,pat1,pat2,pat3,pat4,pat5,pat6,pat7,pat8,pat9... (2 Replies)
Discussion started by: kshitij
2 Replies
LEARN ABOUT DEBIAN
excel::template::element::formula
Excel::Template::Element::Formula(3pm) User Contributed Perl Documentation Excel::Template::Element::Formula(3pm)
NAME
Excel::Template::Element::Formula - Excel::Template::Element::Formula
PURPOSE
To write formulas to the worksheet
NODE NAME
FORMULA
INHERITANCE
Excel::Template::Element::Cell
ATTRIBUTES
All attributes a CELL can have, a FORMULA can have, including the ability to be referenced using the 'ref' attribute.
CHILDREN
None
EFFECTS
This will consume one column on the current row.
DEPENDENCIES
None
USAGE
<formula text="=(1 + 2)"/>
<formula>=SUM(A1:A5)</formula>
<formula text="$Param2"/>
<formula>=(A1 + <var name="Param">)</formula>
In the above example, four formulas are written out. The first two have the formula hard-coded. The second two have variables. The third
and fourth items have another thing that should be noted. If you have a formula where you want a variable in the middle, you have to use
the latter form. Variables within parameters are the entire parameter's value.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
CELL
perl v5.14.2 2010-06-17 Excel::Template::Element::Formula(3pm)