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:

    
  1. Re: Dealing with return characters ( Brian B. Burton 2004)
  2. Re: Dealing with return characters ( Patrick McCormick 2004)
  3. Re: Dealing with return characters ( Larry Hewitt 2004)
  4. Re: Dealing with return characters ( Donovan Brooke 2004)
  5. Re: Dealing with return characters ( Patrick McCormick 2004)
  6. Re: Dealing with return characters ( Brian B. Burton 2004)
  7. Re: Dealing with return characters ( Brian B. Burton 2004)
  8. Re: Dealing with return characters ( Patrick McCormick 2004)
  9. Re: Dealing with return characters ( Patrick McCormick 2004)
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)