Remove CRLf in Access Table fields
Posted on 2014-01-04
I have an Access database with a table that has CRLf characters in several columns; 4 to be exact. These are text fields ( I think limited to 200 characters). I need to export this table to a tab delimited text file that I can use to import into a MySQL database.
In working with an EE Expert, it was suggested that I use this Access coding to remove these; this is an example in ONE of the 4 columns (ServiceComments1): Replace(Replace(Nz([ServiceComments1],""),Chr(10)," "),Chr(13)," ")
I did this & the CRFf's are still in the middle of some of the instances, same as before with NO Replace.
Also, prior to doing the Replace, I did a search, Find of chr(10), Chr(13), Vbcr and vblf on the columns; none found in ANY case.
I might be able to edit this out in the resultant text file bu it is tedious & requires it be manually done for over 100 records in total.
Is there a way I can get this done in Access BEFORE I export the table?