Remove carriage returns from a text file

M

Mike Hicks

I have a text file exported from Access. I need to create that file as one
long string with no carriage or line returns.
 
F

fredg

I have a text file exported from Access. I need to create that file as one
long string with no carriage or line returns.
Click to expand...

If you have a version of Access that supports the Replace function,
you can use:

NewField:Replace([OldField],chr(13) & chr(10),"")

Note:This replaces the return with nothing so you may get text running
together,
"This is line oneThis is line two"

If you want at least a space between the last and first word, use " "
as the replace with argument.
 
Top