Re: Dealing with return characters

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58736
interpreted = N
texte = If you have BBEDIT, I simply load it into BBEDIT; change '\r\r' to some arbitrary weird character(s) not appearing in the data ("+*+" for example); change '\r' to '\t'; then change the wierd character(s) to '\r' You end up with a properly delimited file in about 5 seconds. On Jul 9, 2004, at 11:50 AM, 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/ > > Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.hewittco.comwww.votewashington.org ------------------------------------------------------------- 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)
If you have BBEDIT, I simply load it into BBEDIT; change '\r\r' to some arbitrary weird character(s) not appearing in the data ("+*+" for example); change '\r' to '\t'; then change the wierd character(s) to '\r' You end up with a properly delimited file in about 5 seconds. On Jul 9, 2004, at 11:50 AM, 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/ > > Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.hewittco.comwww.votewashington.org ------------------------------------------------------------- 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/ Larry Hewitt

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:

Date Sorting (1997) Add more fields to an existent data base (1997) WebCat2 beta 11 - new prefs ... (1997) Sorting by date (1997) Transfering [text] variables (2000) Emailer help....! (1997) Where is f2? (1997) Max Record length restated as maybe bug (1997) WebCat Beta NT 18 (1997) Getting total number of items ordered (1997) show all problem (1997) Problems with [Search] param - Mac Plugin b15 (1997) View order not right (1997) Showif for mulitple variations (1997) MySQL Dates and WebDNA (2005) Need Advice for Setting up a Database (1999) WebCat2b12plugin - [search] is broken ... not! (1997) Cold Fusion Buster (1997) Formvariable won't update (1999) LOOP and IF statements (1997)