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 Removed).

Thanks in advance.

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

R. Hicks

"JW" wrote:

> 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 Removed).
>
> Thanks in advance.
>

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...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal

Hi JW

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

Regards

Mike

"JW" wrote:

> 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 Removed).
>
> Thanks in advance.
>

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

"Albert D.Kallal" wrote:

> 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...
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
> http://www.members.shaw.ca/AlbertKallal
>
>
>