Re: Empty fields in database are causinf [if-field bla] to evaluate to true

[Dan Busarow <dan@dpcsys.com>]

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Sun, 28 Mar 1999, Daniel Ceregatti wrote:
> I recently imported a file which was exported by an excel spreadsheet in
> tab delimited format into my products database, using a method provided
> to me by predecessor. Basically, I open vi, s/""/|/g, s/"//g, s/|/"/g to
> eliminate all the double quoting. I then copy it to products.asc and
> make a query, forcing minivend to re-read it. Once I browse through my
> new products using a flypage.html, I keep getting empty
> <select></select> tags on some fields which are supposed to be empty. I
> would like to have browsed the mailing list if I could, but apparently
> it's down to keep the robots out. I hope this is an easy issue to solve,
> I have to have this up very soon. Btw, I've only been using minivend for
> 2 days now. (Is it obvious? :)

Try this for your vi commands, replace \t with a real TAB

s/\t"/\t/g
s/"\t/\t/g

The sub commands you are using are putting a single " in what
could be empty fields.

You could also import the spreadsheet into Access and have Access
create the tab delimited file, you can tell Access not to use "'s

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list