I want to convert a pdf to xls or csv. I used pdftotext to convert the pdf to text. A complication with the original dataset is there are empty spaces. For example, there is an empty space between Gala and Apple in the Product field and in the Quantity field (I put double quotes there but there is an empty space without any characters).
Code:
Date Product Quantity Price
1/1/2013 Gala Apple 100 $1.00
1/2/2013 Gala Apple " " $1.00
1/3/2013 Gala Apple 200 $1.00
I want the final product to be a properly aligned Excel file. Therefore, I would need 'Gala Apple' to be in one cell and preserve the blank cell (or with a unique character signifying there was no data to begin with).
Anyone have a simple fix for this?
By the way, I'm not a sophisticated programmer. I mostly write shell scripts with AWK.
Cheers,
Devin
Last edited by Franklin52; 12-19-2013 at 03:10 AM..
Reason: Please use code tags
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. (1 Reply)
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
Hi,
We have a requirement to send multiple attachment(pdf and csv) along with html content in a single mail. For that we are using uuencode. It is working for single pdf attachment and html content. But we are unable to send both pdf and csv attachment with html content. Below is the script.... (5 Replies)
Discussion started by: dholea
5 Replies
LEARN ABOUT OSX
cupsfilter
cupsfilter(8) Apple Inc. cupsfilter(8)NAME
cupsfilter - convert a file to another format using cups filters
SYNOPSIS
cupsfilter [ -D ] [ -U user ] [ -c config-file ] [ -d printer ] [ -e ] [ -i mime/type ] [ -j job-id[,N] ] [ -m mime/type ] [ -n copies ] [
-o name=value ] [ -p filename.ppd ] [ -t title ] [ -u ] filename
DESCRIPTION
cupsfilter is a front-end to the CUPS filter subsystem which allows you to convert a file to a specific format, just as if you had printed
the file through CUPS. By default, cupsfilter generates a PDF file.
OPTIONS -D
Delete the input file after conversion.
-U user
Specifies the username passed to the filters. The default is the name of the current user.
-c config-file
Uses the named cupsd.conf configuration file.
-d printer
Uses information from the named printer.
-e
Use every filter from the PPD file.
-i mime/type
Specifies the source file type. The default file type is guessed using the filename and contents of the file.
-j job-id[,N]
Converts document N from the specified job. If N is omitted, document 1 is converted.
-m mime/type
Specifies the destination file type. The default file type is application/pdf. Use printer/foo to convert to the printer format
defined by the filters in the PPD file.
-n copies
Specifies the number of copies to generate.
-o name=value
Specifies options to pass to the CUPS filters.
-p filename.ppd
Specifies the PPD file to use.
-t title
Specifies the document title.
-u
Delete the PPD file after conversion.
SEE ALSO cupsd.conf(5)
http://localhost:631/help
COPYRIGHT
Copyright 2007-2013 by Apple Inc.
20 June 2012 CUPS cupsfilter(8)