Re: Spreadsheet App pref. [OT]
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39809
interpreted = N
texte = If you use .hdr files and get a copy of the database manager example from the webcat example site, you should never really need to modify your files in excell or whatever .. ??Why do you need to do this ?> When you import you can specify each field rather than take the blanket > approach eg field one is a number with dollar formating, field two is plain > text, field three is date/time etc. > > i didn't like excell much either, just time taking when downloading / > importing / modifying / exporting / uploading / oops forgot to flush. > > I ended up writing my own browser based generic editing page. not bullet > proof but fine for quick jobs. > > i would give my left arm to hook webcat up to sql server. > > on 1/11/01 9:59 AM, Donovan Brooke at dbrooke@ehg.net wrote: > >> yes, I realize that however, I would like to be able to have it determined on >> output >> or have the default be to not export quotes. This is because our magnificant >> order entry >> ppl have used the for the inch sign in the fields. So, If I import the >> Data w/o quotes to >> define text I get all the quotes (inch signs and text labled). At this point >> I could do something like a find and replace to >> get rid of all the quotes but this would leave all the numbers that represent >> inches labeless. >> If I import the Data with 's as defining text, just the inch quotes are >> imported and I can >> change them from to in.. However, on export the quotes are put back >> in. >> >> Of course, I can then reimport it again into either BBEdit or Excell and then >> delete all the >> quotes however, I thought there might be a better app for this kind of thing >> out there that >> lets you dictate how fields are saved upon export. whew... thought I >> might >> be able to >> get around explaining all that. :-) >> D >> >> >> >> Andrew Simpson wrote: >> >>> When you import the document in the first place it will ask you if you want >>> to differentiate text with quotes. >>> >>> Then when you export it again it remembers. >>> >>> on 1/11/01 9:37 AM, Donovan Brooke at dbrooke@ehg.net wrote: >>> >>>> Questions beget more questions. :-) >>>> >>>> What spreadsheet apps are people using out there on the Mac side of >>>> things.?? >>>> Excell seems to do alright however I don't like a couple things about it. >>>> One, >>>> it is a Microsoft product (reveiling my opinions). Two, when it saves as a >>>> tab-deliminated >>>> text file it puts quotes around most of the fields and I haven't figured >>>> out >>>> how to edit that. >>>> >>>> Any other options out there??? Appleworks? >>>> thanks. >>>> D >> >> -- Donovan D. Brooke >> Systems Administrator/ >> Assc. Art Director >> Epsen Hillmer Graphics >> >> >> I know I'm making progress when I look at the questions I have >> asked in the past and think to myself... how stupid was that >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list
. >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
If you use .hdr files and get a copy of the database manager example from the webcat example site, you should never really need to modify your files in excell or whatever .. ??Why do you need to do this ?> When you import you can specify each field rather than take the blanket > approach eg field one is a number with dollar formating, field two is plain > text, field three is date/time etc. > > i didn't like excell much either, just time taking when downloading / > importing / modifying / exporting / uploading / oops forgot to flush. > > I ended up writing my own browser based generic editing page. not bullet > proof but fine for quick jobs. > > i would give my left arm to hook webcat up to sql server. > > on 1/11/01 9:59 AM, Donovan Brooke at dbrooke@ehg.net wrote: > >> yes, I realize that however, I would like to be able to have it determined on >> output >> or have the default be to not export quotes. This is because our magnificant >> order entry >> ppl have used the for the inch sign in the fields. So, If I import the >> Data w/o quotes to >> define text I get all the quotes (inch signs and text labled). At this point >> I could do something like a find and replace to >> get rid of all the quotes but this would leave all the numbers that represent >> inches labeless. >> If I import the Data with 's as defining text, just the inch quotes are >> imported and I can >> change them from to in.. However, on export the quotes are put back >> in. >> >> Of course, I can then reimport it again into either BBEdit or Excell and then >> delete all the >> quotes however, I thought there might be a better app for this kind of thing >> out there that >> lets you dictate how fields are saved upon export. whew... thought I >> might >> be able to >> get around explaining all that. :-) >> D >> >> >> >> Andrew Simpson wrote: >> >>> When you import the document in the first place it will ask you if you want >>> to differentiate text with quotes. >>> >>> Then when you export it again it remembers. >>> >>> on 1/11/01 9:37 AM, Donovan Brooke at dbrooke@ehg.net wrote: >>> >>>> Questions beget more questions. :-) >>>> >>>> What spreadsheet apps are people using out there on the Mac side of >>>> things.?? >>>> Excell seems to do alright however I don't like a couple things about it. >>>> One, >>>> it is a Microsoft product (reveiling my opinions). Two, when it saves as a >>>> tab-deliminated >>>> text file it puts quotes around most of the fields and I haven't figured >>>> out >>>> how to edit that. >>>> >>>> Any other options out there??? Appleworks? >>>> thanks. >>>> D >> >> -- Donovan D. Brooke >> Systems Administrator/ >> Assc. Art Director >> Epsen Hillmer Graphics >> >> >> I know I'm making progress when I look at the questions I have >> asked in the past and think to myself... how stupid was that >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Alain Russell
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:
errors.db question (2002)
[append] and SSL (1997)
RE: Writefile outside WebSTAR hierarchy? (1997)
[WebDNA] Array for Dummies (2010)
U&P IIS concept (1998)
Looking for a Manual (1997)
[Sum] function? (1997)
mapping fields between databases (2001)
Lost Records in Database (2001)
WC2.0 Memory Requirements (1997)
WebDelivery downloads alias, not original ? (1997)
Sending Mail Confirmation (2002)
More on the email templates (1997)
Multiple prices (1997)
READFILE command? (1998)
Can WC remember people? (1998)
Forms Search Questions (1997)
WebCatalog v2.1.1 (1998)
Physical Security for WebCatalog Directories (1997)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)