• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

Word - Access

Hello All
I have a .dat file that when opened in M/S Word, Notepad or WordPad doesn't recognize the carriage returns. There is a title "~" at the end of each row. I would like to do a edit/replace with a carriage return.
Also can i do it thru code?
I want to open it in ms Acc2010 thru code and process line by line.
Thanks in advance
1 Solution
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
press Ctrl-H for the Find/Replace dialog box in Word

search: ~
replace: ^p

this can be done programmitically as well but it is just a simple Replace in each file.  How many files are there?
frimyAuthor Commented:

It works fine.
I have those files constantly.
How can do it programmatically?
See my comments in  your duplicate question:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now