Paragraph mark in Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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], "~", "")
 
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.

KARL DEWEY said:
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], "~", "")

DOCUBANK said:
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
Click to expand...
Click to expand...
 
Back
Top