Carriage return & Line feeds

[Guest]

I'm importing some data into a MS access memo field and I'm having problems
getting the carriage return / line feeds entered. The text file I'm
importing is a UNIX file that has '\n' for new line entries. Is there any
way to do a search & replace to convert the '\n' characters to a line break
or carriage return?

The search & replace functionality in MS Word allows replacing with special
characters, but I can't figure out how to do it in access.

Please email (e-mail address removed).

Thanks in advance.

 

[Guest]

Use the built in function Replace() to do what you need ...

R. Hicks

 

[Albert D.Kallal]

Well, if you got a backup, then you can whack ctrl-g, and in the command
prompt (immediate) window, you an type:


CurrentDb.Execute "update test1 set YourFieldName =
replace(YourFieldName,chr$(10),chr$(13) & chr$(10))"

Note that this will also operate on existing records, and you don't want to
"run" the update more then once...

 

[Guest]

Hi JW

If 'Replace' is not available to you try Unix2Dos for free at
http://www.shareup.com/Unix2Dos-download-35984.html

Regards

Mike

 

[Guest]

Thanks Albert, I created an update query with your text and it worked like a
charm!