What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

Adding Shipping Costs based on percent of subtotal (1997) Serious bug writing to a database ... (2002) OT: Backup Strategies (2007) Merging databases (1997) supressing math results (1997) WebCatalog and directory indexing (1998) Examples Link? (2000) Has anyone built this already? (2003) ' add to cart ' or ' sku ' problem (1998) Disappearing data (2002) Add htmlarea 3 to SiteBuilder (2004) Setting up shop (1997) WebMerchant? (1998) Norton Antivirus (1999) Beta and new version questions? (1998) Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997) Include files (1998) [WebDNA] eCommerce in 7.0 but not in 7.1? (2012) Re2: frames & carts (1997) RE: [WebDNA] DHL (2008)