New line character

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rohit Chitre - 25 Apr 2005 13:33 GMT

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

Reply to this Message

John Nurick - 26 Apr 2005 13:46 GMT

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.

>Hi ,
>
[quoted text clipped - 4 lines]
>Thanks in advance
>Rohit

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message