Remove carriage returns from a text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text file exported from Access. I need to create that file as one
long string with no carriage or line returns.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

embedded character 2
Find/Replace in csv file - using VB 11
Split data in field on character return 0
Passing string from Access 2003 to Word 2003 form 1
FileSystemObject 3
Carriage Return 7
Carriage Return in Text Box 3
Carriage returns in exported text file 4

Back
Top