Carriage Returns...

[Lee-Anne Waters via AccessMonster.com]

Hi,

i have this table that has approx 1000 records in it. the trouble is in one
of the fields (called Fault) there has been data imported into this field
(memo type)

the problem is this data has carriage returns in it. and it is all a big mess.


is there any way i can run say an update query to find these carriage returns
and actually create a new line after that return.

many thanks for any help..

Lee-Anne

 

[Ken Snell [MVP]]

You can run an update query that uses the Replace function to add the "Line
Feed" character after the "Carriage Return" character in order to make new
lines:

UPDATE MyTableName
SET MyFieldName =
Replace(MyFieldName, Chr(13), Chr(13) & Chr(10), 1, -1, 1);

 

[Lee-Anne Waters via AccessMonster.com]

Thanks very much

You can run an update query that uses the Replace function to add the "Line
Feed" character after the "Carriage Return" character in order to make new
lines:

UPDATE MyTableName
SET MyFieldName =
Replace(MyFieldName, Chr(13), Chr(13) & Chr(10), 1, -1, 1);

Hi,

[quoted text clipped - 13 lines]

Lee-Anne