07-22-2014
I need this done on a daily basis like an automated things so hence I cant format it manually..
second thing is I am looking for a shell script/perl script which will take the csv on unix and give me a formatted xls with all the requirements I specified..
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
Hi,
I have a problem in formatting the excel file from my script.
Assume that there is a text file generated using a 'C shell Unix script' with a format similar to the one seen below. Each column has a fixed length and every row is going to have a value against a column depending on the... (1 Reply)
Discussion started by: subra
1 Replies
2. Shell Programming and Scripting
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies
3. Shell Programming and Scripting
I want to check whether if any column data has any + , - , = prefixed to it then convert it in such a form that in excel its not read as formula.
echo "$DATA" | awk 'BEGIN { OFS="," } -F" " {print $1,$2,$3,$4,$5,$6,$7,$8.$9,$10,$11,$12}' (4 Replies)
Discussion started by: dinjo_jo
4 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
5. Shell Programming and Scripting
Hi,
I am trying to attach and email a csv file in the form of an excel sheet.
And I have been successful in doing this.
But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet.
... (5 Replies)
Discussion started by: girish1428
5 Replies
6. Shell Programming and Scripting
Hi All, Firstly I will like to wish A Happy New Year to all.
Now my issue is
I have one csv file say(data.csv) and one excel file say(result.xls)
The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,... (6 Replies)
Discussion started by: adisky123
6 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 ,
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
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
10. Shell Programming and Scripting
Hello,
I have a file with the below contents :
Policy Name: Backup_bkp
Policy Type: Catalog_bkp
Active: yes
Effective date: 08/07/2013 02:02:12
Mult. Data Streams: no
Client Encrypt: no
Checkpoint: no
Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies
LEARN ABOUT DEBIAN
pct-scanner-script
PCT-SCANNER-SCRIPT(1) General Commands Manual PCT-SCANNER-SCRIPT(1)
NAME
pct-scanner-script - easy scan and create merged DjVu and PDF documents for archiving
SYNOPSIS
pct-scanner-script [--help]
DESCRIPTION
pct-scanner-script is a bash script and configuration system to easily scan documents and create a digital archiving. It can create DjVu
PDF and JPEG outputs, in merged and individual files. It also has a configuration system where different configurations can be defined,
making it easy to switch between configurations.
Please use pct-scanner-script --help to find all program options, the complete help, and all examples.
Features:
- auto archiving in merged and individual DjVu, PDF, and JPEG files
- auto and manual resume when scanning somehow fails
- cascading configuration system, for easy customizing
- easy command-line-style bash program, with useful options
- archiving made possible with both adf and flatbed scanners
- built for productivity and daily use
- uses bash, scanadf and other mainstream processing tools
- multilanguage commandline output
OPTIONS
-h, --help, -?
Show summary of options, help, and examples.
DEBUGGING
This program is a helper script to easy scan and automated digital document archiving for normal and adf scanners. You can debug this
script by running it as bash -x pct-scanner-script [options]. The script is just a nice wrapper for the scanadf, DjVu and PDF tools.
SEE ALSO
scanadf(1),
AUTHOR
pct-scanner-script and this manual page are written by:
Jelle de Jong <jelledejong@powercraft.nl>.
March 31, 2009 PCT-SCANNER-SCRIPT(1)