Removing all carriage returns from a database

[Yesideez]

Any idea how to quickly replace all carriage returns in all fields throughout a database with a space?



I've just spent ages looking up pages in Google and can't seem to find anything.

One idea was to export to XML, search & replace all carriage returns (done successfully) but importing back into Access I get an error telling me the XML format is invalid but doesn't say where.

Is there an easy way to remove these carriage returns?

[ajetrumpet]

you're probably going to have to loop all your tables with code. did you search and repl. the returns AFTER you imported into access? I think you can do that with the dialog in all the tables (CTRL+F) and replace all "vbcr" or "vbcrlf" with something. I know for a fact that the dialog takes those inputs. If not those specifically, others.

I'm 90% sure that recordset code will parse field values out so that you can check for "vbcr" and "vbcrlf". But if you print field values OUT, like to the immediate window, you will only see line feeds in the window if you encounter it in the field value's string. but it can be detected with the above 2 strings.

never have been sure of the diff. between vbcr (vb carriage return) and vbcrlf (vb carriage return line feed), but they both take you to the next line.

[Yesideez]

Thanks, I'll give that a go.

Difference between vbcr and vbcrlf

I'm betting this will be for supporting Unix data and if they both take you to the next line then I'm thinking more for input as Windows uses \r\n for a new line whereas on Unix it only uses \r and I'm thinking vbcr is the latter.