Change special characters

  • Thread starter Thread starter Ngan
  • Start date Start date
N

Ngan

I have a memo field where the user typed in data with line
breaks (or carriage return, not sure which) and stuff.
When I try to export the information, the export doesn't
do the records where the memo fields have these special
characters. How do I go about doing an find and replace
query to find the special character within the memo field
with a correct character so the record can be exported?

Ngan
 
The Carriage Return/Line Feed is actually two characters in the memo field:
Chr(13) and Chr(10).

Create a query that replaces these characters with a space, and export the
query. Type something like this into the Field row of the query grid:
Replace([MyMemo], Chr(13) & Chr(10), " ")

Post back if you are using Access 97 or earlier, as the Replace() function
does not exist.
 
Thank you! This solved a different problem I was having.
This doesn't appear anywhere in the on-line help that I could find, so
thanks again!
Best,
John.


Allen Browne said:
The Carriage Return/Line Feed is actually two characters in the memo field:
Chr(13) and Chr(10).

Create a query that replaces these characters with a space, and export the
query. Type something like this into the Field row of the query grid:
Replace([MyMemo], Chr(13) & Chr(10), " ")

Post back if you are using Access 97 or earlier, as the Replace() function
does not exist.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ngan said:
I have a memo field where the user typed in data with line
breaks (or carriage return, not sure which) and stuff.
When I try to export the information, the export doesn't
do the records where the memo fields have these special
characters. How do I go about doing an find and replace
query to find the special character within the memo field
with a correct character so the record can be exported?

Ngan
Click to expand...
Click to expand...
 
Back
Top