How to remove Tabs/Carriage returns from memo field on export to C

[Guest]

I have a database that has a memo field. When exporting this database to a
CSV file I want all the carriage returns and tabs removed from the field
before exporting to the file. What is the best way to solve this.

 

[Guest]

Have a look at KnowledgeBase article 210433.
It's an article explaining how to write a procedure which will do this for
you. I've just recently done it myself and it work a treat! I've actually
combined the functions so that its just one Function which allows you to be
in arguments to find/replace any character you want.

 

[John Nurick]

If you use a function like the one at
http://support.microsoft.com/?id=210433 in a query to replace the tabs
and carriage returns 'on the fly' and the field contents are longer than
255 characters, they will be truncated when the query is exported. See
http://support.microsoft.com/?id=207668 for details

 

[Guest]

Actually that would not apply as I do not want to change the memo field. All
I want to do is post process the memo field to remove the Tab and Carriage
Returns on exporting to the CSV file.

Thanks. Anybody with suggestions?

 

[Brendan Reynolds]

I don't think you will be able to export the memo field to CSV without
removing the new line characters first. So far as I am aware, there isn't
any practical way to export first and remove the new line characters
afterward.

One solution would be to create a second copy of the table to act as a
'staging' area for export. Copy your data from the original table to this
'staging' table, and make whatever changes are required - e.g. removing the
new line characters - from the data in this 'staging' table before exporting
it, leaving your original data unmodified.