Re: Another Excel Problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51847
interpreted = N
texte = Alain Thanks - 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/ > > 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/
Associated Messages, from the most recent to the oldest:
Alain Thanks - 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/ > > 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/
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:
[SearchString] problem with [search] context (1997)
Trouble with formula.db (1997)
[OT] - See my site? (2004)
[WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010)
Mass download. (2003)
Re:[ShowIf] and empty fields (1997)
AuthorizeNet and SIM (2002)
Is this possible in simple search? question? (1998)
Plugin or CGI or both (1997)
DON'T use old cart file! (1997)
Expected behavior? (1998)
Return records from another (1997)
Sitebuilder and databases not loading correctly (2005)
mass mailing (1998)
carriage returns in data (1997)
Exclamation point (1997)
Doing VALIDCARD right? (1998)
format and math on the fly (1998)
UPDATE PROBLEM (1997)
Searching (2000)