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. Pat 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)
Thanks. You've helped me trim my schizophrenia by at least three personalities. Pat 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:

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)