Re: Spreadsheet App pref. [OT]
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39808
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Andrew Simpson
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:
Trouble with formula.db + more explanation (1997)
Questions To Answer (1997)
[WebDNA] WebDNA 7 (2011)
WebDNA tags in WebMerchant email templates ... (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Multiple catalog databases and showcart (1997)
Looking up two prices in database? (1997)
search form problem.. (1997)
Editor Recommendation for NT Users (1998)
Rollovers (1999)
Only charge card when product shipped ? (1997)
Re1000001: Setting up shop (1997)
WCS Newbie question (1997)
CopyFile not working? (2000)
Signal Raised (1997)
Major Security Hole (1998)
Signal Raised Error (1997)
Max Record length restated as maybe bug (1997)
Emailer setup (1997)
[FileInfo] strangeness (1998)