Re: pipe delimited crconvert database
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43226
interpreted = N
texte = Actually, it's been working it's just unpredictable. I have whittled the problem down to one - one of my records is getting axed.Here's the file I am trying to convert (5day.txt), which is Accuweather in case anyone else out there might want to subscribe to their wacky data service:Saturday|Sunday|Monday|Tuesday|Wednesday KINX|92|60|01|87|58|02|87|59|02|85|57|01|80|51|03| VABR|90|57|01|86|55|02|85|56|02|84|56|01|79|49|02| TN28|90|58|01|84|56|02|86|57|02|85|57|01|80|50|02|Yes, I realize there are two types of records in this file.So, I run a convertwords to get rid of the Sat, sun ,mon stuff. And then I run a convert chars to translate the pipes to tabs.My code:[writefile 5dayFINAL.db][convertchars db=pipeconvert.db][convertwords db=convertpipewords.db][include file=5day.txt][/convertwords][/convertchars][/writefile]I want:KINX 92 60 01 VABR 90 57 01 TN28 90 58 ... etc But what I end up with KINX 92 60 01VABR 90 57 01and the TN28 record is missing.My convertwords db:from to Saturday|Sunday|Monday|Tuesday|Wednesday (a blank tab here) (yes, a return)And the convertchars : from to | %09 Any ideas?-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Kenneth Grome Sent: Friday, September 06, 2002 10:27 PM To: WebCatalog Talk Subject: Re: pipe delimited crconvert database >What does the conversion database for converting pipes to tabs? >There was a discussion that showed: > >from to >| %09 > >But I believe that does not work.This should work fine, assuming you put a carriage return after the %09. Have you tried it? Or are you just assuming that it won't work because of something you read in the archives? If you try it and it really doesn't work, try this instead:from to %7C %09 Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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:
Actually, it's been working it's just unpredictable. I have whittled the problem down to one - one of my records is getting axed.Here's the file I am trying to convert (5day.txt), which is Accuweather in case anyone else out there might want to subscribe to their wacky data service:Saturday|Sunday|Monday|Tuesday|Wednesday KINX|92|60|01|87|58|02|87|59|02|85|57|01|80|51|03| VABR|90|57|01|86|55|02|85|56|02|84|56|01|79|49|02| TN28|90|58|01|84|56|02|86|57|02|85|57|01|80|50|02|Yes, I realize there are two types of records in this file.So, I run a convertwords to get rid of the Sat, sun ,mon stuff. And then I run a convert chars to translate the pipes to tabs.My code:[writefile 5dayFINAL.db][convertchars db=pipeconvert.db][convertwords db=convertpipewords.db][include file=5day.txt][/convertwords][/convertchars][/writefile]I want:KINX 92 60 01 VABR 90 57 01 TN28 90 58 ... etc But what I end up with KINX 92 60 01VABR 90 57 01and the TN28 record is missing.My convertwords db:from to Saturday|Sunday|Monday|Tuesday|Wednesday (a blank tab here) (yes, a return)And the convertchars : from to | %09 Any ideas?-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Kenneth Grome Sent: Friday, September 06, 2002 10:27 PM To: WebCatalog Talk Subject: Re: pipe delimited crconvert database >What does the conversion database for converting pipes to tabs? >There was a discussion that showed: > >from to >| %09 > >But I believe that does not work.This should work fine, assuming you put a carriage return after the %09. Have you tried it? Or are you just assuming that it won't work because of something you read in the archives? If you try it and it really doesn't work, try this instead:from to %7C %09 Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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/
Ben Swihart
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:
Car Database (2002)
WebCat cannot handle compatible search parameters? (1997)
Re:no [search] with NT (1997)
Need a silver bullet (2004)
Not really WebCat- (1997)
Searching multiple fields from one form field (1997)
Multiple fields on 1 input (1997)
show all problem (1997)
[OT] Search Engine Tips (2003)
OT - help with filemaker - short (1999)
HomePage Caution (1997)
Memory Error message (1998)
WebCat2b13MacPlugIn - [include] (1997)
frames & carts (1997)
Reversed words (1997)
My slower response (1997)
Function defined inside Scope context (2005)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
Carts & Refering URLs (1997)
UPPERCASE (1997)