 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / February 2005Remove multiple Chr(13) & Chr(10)
Has anyone cunstructed a function to remove multiple carriage returns and replace it with a single return? Replace(mytext, Chr(13) & Chr(10) & Chr(13) & Chr(10), Chr(13) & Chr(10)) ... only works to remove double carriage returns. Thanks. lq > Has anyone cunstructed a function to remove multiple carriage returns > and replace it with a single return? [quoted text clipped - 6 lines] > Thanks. > lq If you don't need anything elegant or efficient :-): Do While InStr(mytext, Chr(13) & Chr(10) & Chr(13) & Chr(10)) > 0 mytext = YourFunction(mytext) Loop Post back if you need something better. James A. Fortune >>Has anyone cunstructed a function to remove multiple carriage returns >>and replace it with a single return? [quoted text clipped - 16 lines] > > James A. Fortune A little simpler would be: Do While Instr(1,mytext,vbCrLf & vbCrLf) mytext=Replace(mytext,vbCrLf & vbCrLf, vbCrLf) Loop  SignatureThis sig left intentionally blank |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.