Solved

How to find and replace blank fields in open office calc

Posted on 2008-06-11
1
780 Views
Last Modified: 2013-12-27
I have 6 columns and there are a few row entries that are blank in columns 2 and 3.   How can I find and replace those banks with '0's?  I'm trying to use phpPGadmin to import a csv file into a table and it wont take blanks in double precision fields.

Thanks,
Sean

SQL error:
 

ERROR:  invalid input syntax for type double precision: ""
 

In statement:

INSERT INTO "temp" ("zip", "lat", "lon", "city", "abr", "county", "type") VALUES ('29588', '', '', 'MYRTLE BEACH', 'SC', 'HORRY', 'STANDARD')

Open in new window

0
Comment
Question by:sean-keys
1 Comment
 
LVL 24

Accepted Solution

by:
fridom earned 500 total points
ID: 21784297
Move away the two columns then on at the other place write someting like
=if(CellMoved <> ""; CellMoved; 0,0)

Well you could of course change the insert statement if you like...

Regards
Friedrich

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
filter options in excel 2013 or 2016 3 41
Check version 13 69
outlook 2013 key shortcuts 28 52
Multiple Edits to change a name in Conditional Formatting Excel 2010 8 36
This article will show you how to use shortcut menus in the Access run-time environment.
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now