Re: Dealing with return characters
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58731
interpreted = N
texte = Spoke too soon.Grep seems only to replace the first occurrence and none of the rest. Any reason for this?On 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:
Spoke too soon.Grep seems only to replace the first occurrence and none of the rest. Any reason for this?On 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:
WebMerchant Q (2000)
Formating found categories (1997)
Resetting a Formvariable (2000)
Authenticate (1999)
Online CC Processing (2002)
required fields (1999)
Smith Micro - no competition (2000)
[writefile] (1997)
Too Many Items found (2000)
International Orders (1998)
Date search - yes or no (1997)
Bug alert! (1997)
Re:Help name our technology! (1997)
Sorting by date (1997)
Nesting format tags (1997)
Multiple Replaces? (1997)
[sendmail] and [formvariables] (1997)
LetterRip and WebCat (1998)
Date Formats (1997)
Mixing and/or in searches (1998)