OT: Finding a carriage return in an Access field and removing it....

  • Thread starter Thread starter D. Shane Fowlkes
  • Start date Start date
D

D. Shane Fowlkes

Sorry for the OT post but I've looked around for a bit and cannot find a
solution to what would seem a common problem. I considered posting in an
Access NG but they don't seem to have much traffic these days. I have a 3rd
party MS Access table and one of the fields in the table is littered with
carriage returns. These need to be removed but I don't know how. How can I
use a Find & Replace in Access to remove all carraige returns and/or line
feeds in a field so I can cleanly export to a txt file? Surely there's a
way to do this......

TIA
 
PS - and to clarify, the carriage returns to not show up in the record as a
visible character so I cannot copy it to be replaced. I know sometimes you
see a "square" that you can copy to use in a Find & Replace but not this
time....
 
String.Replace(Environment.NewLine, "")

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Back
Top