Sponsored Content
Full Discussion: Pdf to xls or csv Linux
Top Forums UNIX for Dummies Questions & Answers Pdf to xls or csv Linux Post 302880261 by Devin Boyarko on Wednesday 18th of December 2013 11:55:38 AM
Old 12-18-2013
Code Pdf to xls or csv Linux

Hello,

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
 

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. (1 Reply)
Discussion started by: miltony
1 Replies

2. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 Replies

3. Shell Programming and Scripting

.xls to .csv conversion

Hi Please can someone tell me how i can convert .xls file into .csv on both platforms, windows and unix. many thanks, neil (4 Replies)
Discussion started by: neil546
4 Replies

4. Shell Programming and Scripting

xls to csv

how to convert a xls file into .csv file? is tghere any command in unix for that? please help thanks (3 Replies)
Discussion started by: infyanurag
3 Replies

5. 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 (6 Replies)
Discussion started by: bandar007
6 Replies

6. Shell Programming and Scripting

how to convert .xls to .csv

Hi, I have problem..How to convert .xls file to .csv.. Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies

7. Shell Programming and Scripting

CSV to XLS

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)
Discussion started by: chipmunken
3 Replies

8. Shell Programming and Scripting

Oracle to CSV to XLS

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)
Discussion started by: javeiregh
3 Replies

9. Shell Programming and Scripting

Csv to xls

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)
Discussion started by: frhling
1 Replies

10. Shell Programming and Scripting

Mail sending with multiple attachement(pdf and csv) with html content from Linux

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
IPHETH(4)						   BSD Kernel Interfaces Manual 						 IPHETH(4)

NAME
ipheth -- USB Apple iPhone/iPad tethered Ethernet driver SYNOPSIS
To load the driver as a module at boot time, place the following line in loader.conf(5): if_ipheth_load="YES" Alternatively, to compile this driver into the kernel, place the following lines in your kernel configuration file: device uhci device ohci device usb device ipheth DESCRIPTION
The ipheth driver provides support for network access through Apple iPhone and iPad devices, often referred to as USB tethering. ipheth should work with any Apple iPhone or iPad device. In most cases this must be explicitly enabled on the device first. For more information on configuring this device, see ifconfig(8). The device does not support different media types or options. HARDWARE
The following devices are supported by the ipheth driver: o Apple iPhone tethering (all models) o Apple iPad tethering (all models) SEE ALSO
arp(4), cdce(4), intro(4), netintro(4), urndis(4), usb(4), ifconfig(8), usbconfig(8) HISTORY
The ipheth device driver first appeared in FreeBSD 8.2. AUTHORS
The ipheth driver was written by Hans Petter Selasky <hselasky@FreeBSD.org>. BUGS
Some devices may need to be manually configured to use an alternative configuration with the usbconfig(8) utility. A command similar to usbconfig -u 1 -a 2 set_config 3 may be required if the device is not recognised automatically by ipheth after it is connected. BSD
September 30, 2014 BSD
All times are GMT -4. The time now is 07:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy