If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What is the box character in a text field and how do I replace it?
I have a text\memo filed that has a box charter(s) in it. I do not remember
if it is a carriage return or whatever. Whats is the character and how do I replace it? Thanks Dave |
#2
|
|||
|
|||
What is the box character in a text field and how do I replace it?
On Tue, 27 Apr 2010 06:46:01 -0700, Dave
wrote: I have a text\memo filed that has a box charter(s) in it. I do not remember if it is a carriage return or whatever. Whats is the character and how do I replace it? Thanks Dave You'll need to find out what it is. My guess is that it's a linefeed Chr(10) - it wouldn't hurt to make a backup of your database just in case, and run a query SELECT memofield, InStr([memofield], Chr(10)) FROM tablename WHERE memofield LIKE "*" & Chr(10) & "*" to see if it shows the records with the box and the position of the linefeed. Count characters and see if it matches. You could then run an Update query updating the memo field: UPDATE tablename SET memofield = Replace([memofield], Chr(10), "") Note that if the field has legitimate carriage return-linefeed characters this will do more harm than good! -- John W. Vinson [MVP] |
#3
|
|||
|
|||
What is the box character in a text field and how do I replace it?
SELECT YourTable.YourField,
Replace([YourTable]![YourField],Chr(13)," ") AS WO_Characters FROM YourTable WHERE (((YourTable.YourField) Like "*" & Chr(13) & "*")); Use something like above and replace the 13 with the various non-prining ASCII characters. 13 and 10 are good places to start. Next make a backup of the database. You might even want to make a copy for testing. Change the 13 below to the value you fine above. This update query will replace it with a space. UPDATE YourTable SET YourTable.YourField = Replace([YourTable]![YourField],Chr(13)," "); -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Dave" wrote: I have a text\memo filed that has a box charter(s) in it. I do not remember if it is a carriage return or whatever. Whats is the character and how do I replace it? Thanks Dave |
Thread Tools | |
Display Modes | |
|
|