Search and Replace

S

Steve Roberts

I've imported a table with a memo field in which I've
used "QQQ" to signify whare I need line feeds/carriage
returns (there are lots, in lots of records!).

I can't find how to specify replacing text with an "LF"
(ascii 12) or CR (ascii 15) character.

Can anyone help ?

thanks, Steve Roberts
 
A

Allen Browne

1. Create a query into this table.

2. Change it to an Update query: Update on Query menu.
Access adds an Update row to the grid.

3. Drag the memo field into the grid. We will call it MyMemo in this
example.

4. In the Update row under MyMemo, enter:
Replace([MyMemo], "QQQ", Chr(13) & Chr(10))

5. Run the update query.
 

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

Text box behavior? 2
Carriage Return Line Feed 4
Replace Carriage Return ASCII Character in Memo Field 3
Replace carriage return 2
Access 2003 add a carriage return, line feed inside a memo field7 1
Query returns Arabic and/or sanskrit characters 4
Scanning Through "Memo" Field Is Very Slow 5
Search and Replace -- non-ASCII charaters 9

Top