Remove carriage returns in memo fields

  • Thread starter Thread starter judith
  • Start date Start date
J

judith

I have imported some data from Excel where the Alt+ Enter has been used to
line space information in a cell. This comes over as | type character. Any
suggestion please as to how I can relace these characters with a carriage
return in the imported memo field.

Thanks
 
judith said:
I have imported some data from Excel where the Alt+ Enter has been used to
line space information in a cell. This comes over as | type character. Any
suggestion please as to how I can relace these characters with a carriage
return in the imported memo field.
Click to expand...
Run an UPDATE query like this:

UPDATE [yourTable]
SET [yourMemoField] = Replace([yourMemoField],
Chr(10),
Chr(13) & Chr(10))

imho Excel only uses the Lf character:

Chr(10) is Lf
Chr(13) & Chr(10) is CrLf

be sure, that you have a backup copy of your table/database before
trying it.

mfG
--> stefan <--
 
Back
Top