| John Nurick 2005-04-26, 9:24 am |
| Hi Rohit,
Use an update query with a criterion like this, where XXX is the name of
the field.
Right([XXX], 2) = Chr(13) & Chr(10)
and an Update To expression like this
Left([XXX], Len([XXX]) - 2)
In SQL view it's something like
UPDATE MyTable
SET XXX = Left([XXX], Len([XXX]) - 2)
WHERE Right([XXX], 2) = Chr(13) & Chr(10)
;
This assumes that they have the standard Windows CR+LF for newline; if
it's something else, adjust the expressions as appropriate.
On Mon, 25 Apr 2005 12:33:34 GMT, "Rohit Chitre via AccessMonster.com"
<forum@nospam.AccessMonster.com> wrote:
>Hi ,
>
>I have a table with data over 1 lak records . Few of these records have New
>line characters appended to them. Is there any way to remove this new line
>character?
>
>Thanks in advance
>Rohit
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|