Re: Dealing with return characters
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58730
interpreted = N
texte = Thanks. You've helped me trim my schizophrenia by at least three personalities.PatOn Jul 9, 2004, at 2:02 PM, Brian B. Burton wrote:> here's the code you need based on a thingy i made to clean up that > excuse MS calls a tab-delimited text file that Excel produces.>> [text]stuff=[include file=startfile][/text]>> [text]stuff=[grep > search=%0A%0D%0A%0D&replace=NEWRECORD][stuff][/grep][/text]> [text]stuff=[grep search=%0A%0D&replace=%09][stuff][/grep][/text]> [text]stuff=[grep search=NEWRECORD&replace=%0A%0D][stuff][/grep][/text]>> [writefile file=output.db&secure=F][stuff][/writefile]>>>> Brian B. Burton> Burton Logistics> 973-263-3036 973-296-6862 (cell)> Specializing in website design and development to make your customers > exclaim:> "Out of all the websites I visit, yours is the easiest to use!">>>>> On Jul 9, 2004, at 1:50 PM, Patrick McCormick wrote:>>> I need to populate a db from text files. Text file has return >> character between what will be each field and two returns between >> what will become records:>>>> Name1>> Addr1>> City1, St1, Zip1>>>> Name2>> Addr2>> City2, St2, Zip2>>>> .>> .>> .>>>> I can convert all the returns to tabs or something else, but I need >> to distinguish between single and double returns to maintain >> individual records. What's the easiest way?>>>> Thanks,>> Pat>>>>>> ------------------------------------------------------------->> 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/>-------------------------------------------------------------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. You've helped me trim my schizophrenia by at least three personalities.PatOn Jul 9, 2004, at 2:02 PM, Brian B. Burton wrote:> here's the code you need based on a thingy i made to clean up that > excuse MS calls a tab-delimited text file that Excel produces.>> [text]stuff=[include file=startfile][/text]>> [text]stuff=[grep > search=%0A%0D%0A%0D&replace=NEWRECORD][stuff][/grep][/text]> [text]stuff=[grep search=%0A%0D&replace=%09][stuff][/grep][/text]> [text]stuff=[grep search=NEWRECORD&replace=%0A%0D][stuff][/grep][/text]>> [writefile file=output.db&secure=F][stuff][/writefile]>>>> Brian B. Burton> Burton Logistics> 973-263-3036 973-296-6862 (cell)> Specializing in website design and development to make your customers > exclaim:> "Out of all the websites I visit, yours is the easiest to use!">>>>> On Jul 9, 2004, at 1:50 PM, Patrick McCormick wrote:>>> I need to populate a db from text files. Text file has return >> character between what will be each field and two returns between >> what will become records:>>>> Name1>> Addr1>> City1, St1, Zip1>>>> Name2>> Addr2>> City2, St2, Zip2>>>> .>> .>> .>>>> I can convert all the returns to tabs or something else, but I need >> to distinguish between single and double returns to maintain >> individual records. What's the easiest way?>>>> Thanks,>> Pat>>>>>> ------------------------------------------------------------->> 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/>-------------------------------------------------------------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/
Patrick McCormick
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:
search form problem.. (1997)
Calendar Snippet Problems (1998)
Table code broken? (2004)
While I'm on Cookies... :-) (2004)
Targeted Redirect (1999)
carriage returns in data (1997)
[TaxableTotal] - not working with AOL and IE (1997)
WCS Newbie question (1997)
Banner DNA (1997)
Ticks Email Preference (2002)
Duplicate Hell (1999)
RE: Missing contexts on NT (1997)
taxTotal, grandTotal (1997)
Locking up with WebCatalog... (1997)
New Site Announcement (1998)
[isfolder] and [filename] (1997)
Searching Relational Databases (2004)
Many are called but only 6 make it to founditems. (2001)
Formating found categories (1997)
[WebDNA] WebDNA version 7 feature list? (2011)