Re: tabs as delimiters
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59581
interpreted = N
texte = Thanks again, but using %1D gets me right back where I started with the pipe char: empty values collapse. The tab=t parameter is for making empty values valid when reading tab-delimited text, but as we can see, you can't pull a tab out of a DB field.I'm going to have to do something different. Shouldn't be hard, but I don't see why SMSI couldn't make tabs=T apply to whatever delimiter you happen to be using either.Thanks,TerryKen wrote:>Thanks Ken. Yes, now that you point this out, it's perfectly clear.>Of course I know you can't put tabs in field - why didn't I see>that? I wonder why they use the tabs=t in the first place for>listwords?Probably because listwords isn't always used on database fieldvalues, sometimes it is used on text that actually has tabs in it.But I have never used the optional tabs=t parameter myself so I don'treally know what it's there for ...>Now I see what's happening. The stored value is correct, but with>another character in place of tabs. Inspecting my database in BBedit>I find the tab char is now replaced with /0x1D whatever that is.So now you can use [listfields delimiters=%1D&words=[yourwordshere]]and it should work fine, assuming the rest of your code is okay.-- >On Oct 8, 2004, at 11:40 AM, Terry Wilson wrote:>>> When you use a tab as a delimiter in a string so you can split it >>apart later via listwords, with blank entries intact:>>-------------------------------------------------------------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:
Thanks again, but using %1D gets me right back where I started with the pipe char: empty values collapse. The tab=t parameter is for making empty values valid when reading tab-delimited text, but as we can see, you can't pull a tab out of a DB field.I'm going to have to do something different. Shouldn't be hard, but I don't see why SMSI couldn't make tabs=T apply to whatever delimiter you happen to be using either.Thanks,TerryKen wrote:>Thanks Ken. Yes, now that you point this out, it's perfectly clear.>Of course I know you can't put tabs in field - why didn't I see>that? I wonder why they use the tabs=t in the first place for>listwords?Probably because listwords isn't always used on database fieldvalues, sometimes it is used on text that actually has tabs in it.But I have never used the optional tabs=t parameter myself so I don'treally know what it's there for ...>Now I see what's happening. The stored value is correct, but with>another character in place of tabs. Inspecting my database in BBedit>I find the tab char is now replaced with /0x1D whatever that is.So now you can use [listfields delimiters=%1D&words=[yourwordshere]]and it should work fine, assuming the rest of your code is okay.-- >On Oct 8, 2004, at 11:40 AM, Terry Wilson wrote:>>> When you use a tab as a delimiter in a string so you can split it >>apart later via listwords, with blank entries intact:>>-------------------------------------------------------------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/
Terry Wilson
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:
Still having problems with Authen (1997)
multiple databases (1997)
Windows Install issue (2003)
Help formatting search results w/ table (1997)
Updating checkboxes made easy !!! (1998)
WebCat editing, SiteGuard & SiteEdit (1997)
Speed questions (1998)
nested context (1998)
A sendmail warning (2005)
Web Catalog vs. ICAT (1997)
Re:2nd WebCatalog2 Feature Request (1996)
WebCatalog can't find database (1997)
[WebDNA] output of all non alphaNumeric characters? (2009)
Q: writefile and uploads. (1998)
STRANGE (2001)
LIstFiles - filnames are cart numbers. (2000)
More on the email templates (I like it) (1997)
no global [username] or [password] displayed ... (1997)
emailer on Windows Beta 18 (1997)
ConvertChars - german umlauts (1998)