Converting .xls into .csv and find & Replace Post: 302435212

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Hi, Can anyone tell the option to change the file type in unix. i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format. Thanks in advance, Milton.

2. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks

3. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column...

4. Shell Programming and Scripting

Find & Replace string in multiple files & folders using perl

find . -type f -name "*.sql" -print|xargs perl -i -pe 's/pattern/replaced/g' this is simple logic to find and replace in multiple files & folders Hope this helps. Thanks Zaheer

5. Shell Programming and Scripting

find & replace comma in a .csv file.

HI, Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ). How to do it. Please help. Sample text: "1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"...

6. UNIX for Dummies Questions & Answers

converting xls,xlsx files ??

I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know. Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ? Thanks in advance. Floyd

7. Shell Programming and Scripting

Converting huge xls(having multiple tabs) to csv

hello I have browsed for the similar requirement i found this https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html but my problem is i have multiple tabs in xls file having same metadata I want to convert it into single csv file any ways to do it pls...

8. Shell Programming and Scripting

Converting a list to X columns of csv (& wrapping a command around it)

Hi All, Random question, how would you convert a data file from a list like so: 12345 12346 12347 12348 12349 12350 ... <snip 100+ lines> ... to comma separated X columns across: 12345,12346,12347 12348,12349,12350 Why would you want to do this? The background to this is a...

9. Shell Programming and Scripting

Find and replace variables using a csv table

I have a flat file (template) where I want to replace variables based upon a value in another file (csv). The variables in the template are named %VAR_X_z% The values are in the csv file and X is field 0 of each line and y field 1 and up. Example of the csv: Badidas, 13.00, 12.00, 11.00,...

10. Shell Programming and Scripting

Script for converting to xls and to mail the same

i have installed CENTOS in VMware. I want the linux command to run in CENTOS. The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script. Thanks, Shobana

LEARN ABOUT CENTOS

gsf-office-thumbnailer

GSF-OFFICE-THUMBNAILER(1)					       GNOME						 GSF-OFFICE-THUMBNAILER(1)

NAME

       gsf-office-thumbnailer - office files thumbnailer for the GNOME desktop

SYNOPSIS

       gsf-office-thumbnailer [OPTIONS] infile outfile

DESCRIPTION

       This manual page briefly documents the gsf-office-thumbnailer command.

       gsf-office-thumbnailer is used internally by GNOME applications such as nautilus to generate thumbnails of several types of office applica-
       tion files. While it is possible to invoke it manually, it is usually invoked automatically by nautilus.

OPTIONS

       This program follows the usual GNU command line syntax, with single letter options starting with a single dash  (`-')  and  longer  options
       starting with two dashes (`--').

   Main options
       -i, --input=filename
	      Name of file for which to create a thumbnail

       -o, --output=filename
	      Name of the file in which to store the thumbnail

       -s, --size=N
	      Size of thumbnail in pixels; the thumbnail will be at most N*N pixels large.

   Help options
       -?, --help
	      Display a brief usage message

LICENSE

       gsf-office-thumbnailer  is licensed under the terms of version 2.1 of the GNU Lesser General Public License (LGPL) as published by the Free
       Software Foundation. For information on this license look at the source code that came with the software or see the GNU project page
       <http://www.gnu.org/>.

AUTHOR

       gsf-office-thumbnailer's primary author is Federico Mena-Quintero <federico@novell.com>.

       The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.

gsf								  August 17, 2005					 GSF-OFFICE-THUMBNAILER(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Discussion started by: miltony

2. Shell Programming and Scripting

converting xls file to txt file and xls to csv

Discussion started by: bandar007

3. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Discussion started by: krthkmuthu

4. Shell Programming and Scripting

Find & Replace string in multiple files & folders using perl

Discussion started by: Zaheer.mic