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:
did I miss anything (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Dubble Sku's in a Database (1999)
Document Contains No Data msg (1997)
Page Breaks in Word (2003)
Rhapsody? (1997)
Image Library (2003)
ADD a product without Database (1998)
Setting up WebCatalog with Retail Pro data (1996)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[WebDNA] New problem with [ShowNext] (2010)
Sort Order on a page search (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
unitshipcost vs shipcosts (1997)
problems with 2 tags shakur (1997)
Help formatting search results w/ table (1997)
UPS problems (again) (2000)
PSC recommends what date format yr 2000??? (1997)
New WebDNA Forum Solution (in development) (2003)
[protect admin] (1997)