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 = 20367
interpreted = N
texte = 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. > >SteveMail to: jv1@web-maya.com Visit my Page: http://www.web-maya.com1) Life is what happens, while you are making plans! 2) Life is what happens as we walk through eternity! 3) We are all one. Associated Messages, from the most recent to the oldest:

    
  1. Re: Why do extra quotation marks sometimes appear in my databases? (PCS Technical Support 1998)
  2. Re: Why do extra quotation marks sometimes appear in my databases? (Jose A. Gordo 1998)
  3. Re: Why do extra quotation marks sometimes appear in my databases? (Jim V 1998)
  4. Why do extra quotation marks sometimes appear in my databases? (Steve Rosenbaum 1998)
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. > >SteveMail to: jv1@web-maya.com Visit my Page: http://www.web-maya.com1) Life is what happens, while you are making plans! 2) Life is what happens as we walk through eternity! 3) We are all one. Jim V

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:

Changing price for a SLU based on options (size, etc.) (1997) Trouble with formula.db (1997) Up and running ... at last !! (1997) WCS Newbie question (1997) Re:Need help... (1997) Grep (2003) OT Pager notification of completed orders (1998) email server and webdna (2006) Formulas.db + Users.db (1997) Different Drive (2003) test (2000) WebCat2: Master Counter snippet (1997) [math date] with non-US date format (2000) WebCat for Unix?? (1997) Shopping cart problem (2003) [WebDNA] triggers.db "next execute" fails to update (2012) Monitor Hard Disk Space? (2003) passing search criteria (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) Preventng cacheing (2000)