Re: Why do extra quotation marks sometimes appear in my databases?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20373
interpreted = N
texte = Jim,I might be wrong since I had a customer who had this problem a while ago, and I don't recall the details anymore. However, if I'm not mistaken I believe this happened only to cells with numbers in them and he cleared the problem by formatting the column as a General number rather than Currency. Like I said though this was a while ago and the details are fuzzy. If anybody has more information on this topic I would like to hear about it since we are currently working on a project that uses several large databases that a customer has created in Excell and I would like to avoid any problems down the road since the customer plans on updating the databases himself.Thanks, JoseJim V wrote: > > Steve, > > One of my clients ran into this problem. It is a function within Excel. > I suggest that you have the dbase opened in another program like Claris > Works, saved as TEXT then open it > in Excel as TEXT. > This will prevent Excel from adding its features to the file. > I do not think you can disable this in the options, it is part of the > smart editing of MS Products. > Jim > > >List members, > > > >Does anyone have a clue as to why extra quotation marks sometimes appear in > >my databases? > > > >Sometimes, if a field has quotation marks in it, all of the quotation marks > >become double quotation marks and the entire field gets wrapped in a set of > >single quotation marks. > > > >This has happened to me under the following two circumstances in the past > >day relating to 2 different sites, > > > >1) When saving and then reopenning a tab-delimited file in MS Excel for > >Win 98. > >2) When submitting modifications to a database via a WebDna-based template. > > > > > >All ideas/suggestions welcome. > > > >Steve > > Mail to: jv1@web-maya.com > Visit my Page: http://www.web-maya.com > > 1) Life is what happens, while you are making plans! > 2) Life is what happens as we walk through eternity! > 3) We are all one.-- ----------------------------------------------------- The International Website Construction Co. http://www.iwcc.com/Miami --- Sao Paulo --- Buenos Aires --- Lima Web Advertising and Design for the Latin American Market voice: (305) 666-1012 3714 Matheson Ave. Coconut Grove, FL 33133, USA -----------------------------------------------------
Associated Messages, from the most recent to the oldest:
Jim,I might be wrong since I had a customer who had this problem a while ago, and I don't recall the details anymore. However, if I'm not mistaken I believe this happened only to cells with numbers in them and he cleared the problem by formatting the column as a General number rather than Currency. Like I said though this was a while ago and the details are fuzzy. If anybody has more information on this topic I would like to hear about it since we are currently working on a project that uses several large databases that a customer has created in Excell and I would like to avoid any problems down the road since the customer plans on updating the databases himself.Thanks, JoseJim V wrote: > > Steve, > > One of my clients ran into this problem. It is a function within Excel. > I suggest that you have the dbase opened in another program like Claris > Works, saved as TEXT then open it > in Excel as TEXT. > This will prevent Excel from adding its features to the file. > I do not think you can disable this in the options, it is part of the > smart editing of MS Products. > Jim > > >List members, > > > >Does anyone have a clue as to why extra quotation marks sometimes appear in > >my databases? > > > >Sometimes, if a field has quotation marks in it, all of the quotation marks > >become double quotation marks and the entire field gets wrapped in a set of > >single quotation marks. > > > >This has happened to me under the following two circumstances in the past > >day relating to 2 different sites, > > > >1) When saving and then reopenning a tab-delimited file in MS Excel for > >Win 98. > >2) When submitting modifications to a database via a WebDna-based template. > > > > > >All ideas/suggestions welcome. > > > >Steve > > Mail to: jv1@web-maya.com > Visit my Page: http://www.web-maya.com > > 1) Life is what happens, while you are making plans! > 2) Life is what happens as we walk through eternity! > 3) We are all one.-- ----------------------------------------------------- The International Website Construction Co. http://www.iwcc.com/Miami --- Sao Paulo --- Buenos Aires --- Lima Web Advertising and Design for the Latin American Market voice: (305) 666-1012 3714 Matheson Ave. Coconut Grove, FL 33133, USA -----------------------------------------------------
Jose A. Gordo
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
RE: strip .0 off off IPaddress (1998)
Cart ID Duplication (2001)
WCf2 and nested tags (1997)
Page Counters? (1997)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
WebCatalog 3.0.8 is on FTP... (2000)
Navigator Parsing (1997)
PCS Frames (1997)
RE: date (1998)
FEATURE REQUEST: Auto Resizing of images (2002)
WebCatalog Hosting (1996)
Mime Headers for Mail (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Which GUI HTML editors work with WC ? (1997)
Group search - using contexts (2000)
Weird problems with [SHOWIF]s (1997)
FW: 2.01 upgrade problems (1997)
wee problem (2001)
Exclamation point (1997)