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

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

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.
 
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.
 
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?
 
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.
 
Back
Top