Re: Another Excel Problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51847
interpreted = N
texte = AlainThanks - that worked perfectly :)On Wednesday, July 23, 2003, at 11:06 AM, Alain Russell wrote:> You will get this error if any of the fields contain a carriage return > or> tab or some other webdna [url]'d value. e always get around this by > writing> out files in .csv format>> "[field]","[field2]" etc etc ..>> Alain>> ----- Original Message -----> From: "Stuart Tremain"
> To: "WebDNA Talk" > Sent: Wednesday, July 23, 2003 12:43 PM> Subject: Another Excel Problem>>>> This creates a tab delimited file that I hope would open in Excel.>>>> [Search db=recall.db&geIDdatarq=0&asIDsort=1&IDtype=num]>>>> [WriteFile>> file=recallreports/recall[math]{[date]}[/math].xls]ID dBDate dBTime>> Salutation Firstname Surname Address City State Zip Country Phone >> Email>> Model SerialNumber>> [FoundItems]>> [ID] [dBDate] [dBTime] [Salutation] [Firstname] [Surname] [Address]>> [City] [State] [Zip] [Country] [Phone] [Email] [Model] >> [SerialNumber][/>> FoundItems][/WriteFile]>>>> [/Search]>>>> Unfortunately I get an error "SYLK: File format is not valid" when>> opening in Excel.>>>> any ideas?>>>>>> Regards>>>> Stuart Tremain>> idfk web developments>> 114a/40 yeo street neutral bay 2089 australia>> t +612 9908 2134>> f +612 9908 4837>>>>>> ------------------------------------------------------------->> 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://webdna.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://webdna.smithmicro.com/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
AlainThanks - that worked perfectly :)On Wednesday, July 23, 2003, at 11:06 AM, Alain Russell wrote:> You will get this error if any of the fields contain a carriage return > or> tab or some other webdna [url]'d value. e always get around this by > writing> out files in .csv format>> "[field]","[field2]" etc etc ..>> Alain>> ----- Original Message -----> From: "Stuart Tremain" > To: "WebDNA Talk" > Sent: Wednesday, July 23, 2003 12:43 PM> Subject: Another Excel Problem>>>> This creates a tab delimited file that I hope would open in Excel.>>>> [Search db=recall.db&geIDdatarq=0&asIDsort=1&IDtype=num]>>>> [WriteFile>> file=recallreports/recall[math]{[date]}[/math].xls]ID dBDate dBTime>> Salutation Firstname Surname Address City State Zip Country Phone >> Email>> Model SerialNumber>> [founditems]>> [ID] [dBDate] [dBTime] [Salutation] [Firstname] [Surname] [Address]>> [City] [State] [Zip] [Country] [Phone] [Email] [Model] >> [SerialNumber][/>> FoundItems][/WriteFile]>>>> [/Search]>>>> Unfortunately I get an error "SYLK: File format is not valid" when>> opening in Excel.>>>> any ideas?>>>>>> Regards>>>> Stuart Tremain>> idfk web developments>> 114a/40 yeo street neutral bay 2089 australia>> t +612 9908 2134>> f +612 9908 4837>>>>>> ------------------------------------------------------------->> 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://webdna.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://webdna.smithmicro.com/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------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://webdna.smithmicro.com/
Stuart Tremain
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:
Nested tags count question (1997)
Text data with spaces in them... (1997)
date pref (1999)
Generating Pages (1999)
Help name our technology! I found it (1997)
Mac Vs WindowsNT (1997)
Quit revisited (1997)
5.0 feature request: Sort for ListWords (2001)
WebCat2b13MacPlugIn - More limits on [include] (1997)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
[WebDNA] Privat IP website behind a public IP website (2014)
Pricing (1998)
PIXO with cometsite ... and/or other plugins (1998)
alternatives for WebDNA (2004)
update on include (1997)
Updating a database once per day - An example (1998)
New servers and new inline cache (1997)
Excuse me for a second (2000)
Showing once on a founditems (1997)
Help! WebCat2 bug (1997)