Paragraph mark in Data

[Guest]

I have some old data in a table which contains paragraph marks. How do I
query the table to find the offending characters so they can be deleted? The
marks are in the middle of the data so I have to use a wildcard of some sort.

Thanks

 

[Guest]

If you know where one is then try to capture it on the clipboard. Then paste
in a select query like this --
CKparaMark: InStr([YourFieldName], "~") pasting the mark as I used
the tilde.

If you can then you can use an update query with this as the UpdateTo --
Replace([YourFieldName], "~", "")

 

[Guest]

It worked great. I used Chr(13) to find the paragraph mark since I couldn't
"paste" ithe mark into the expression builder, i.e. PARMARK= INSTR([PHNAME],
Chr(13)). In the query criteria line, I entered > 0 and it listed the
problem records.

Thanks so very much.

If you know where one is then try to capture it on the clipboard. Then paste
in a select query like this --
CKparaMark: InStr([YourFieldName], "~") pasting the mark as I used
the tilde.

If you can then you can use an update query with this as the UpdateTo --
Replace([YourFieldName], "~", "")

I have some old data in a table which contains paragraph marks. How do I
query the table to find the offending characters so they can be deleted? The
marks are in the middle of the data so I have to use a wildcard of some sort.

Thanks