Delete carriage returns

I have some fields where someone has used carriage returns with data entry.
Now, I need to export this data into a flat text file, and these carriage
returns are obviously messing up the record layout. Is there any way to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10241-delete-carriage-returns.html
delete these carriage returns from my Access fields before I export to a text
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241
file?

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On Wed, 24 May 2006 1002 -0700, kayabob wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241

> I have some fields where someone has used carriage returns with data entry.
> Now, I need to export this data into a flat text file, and these carriage
> returns are obviously messing up the record layout. Is there any way to
> delete these carriage returns from my Access fields before I export to a text
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241
> file?

If your version of Access supports the Replace Function, you can run
an update query to replace all of the returns (with what?)
This Update query replaces the returns with a single space.
Use "" if you want to replace the returns with nothing.

Back up your table first.

Update YourTable Set YourTable.FieldName = Replace([FieldName],chr(13)
& chr(10)," ");
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

I tried this but got a message: "6441 conversion failures due to type
conversion". 6441 seems like it might be about the right # of carriage
returns found. I was trying to replace the carriage return with 2 spaces.

"fredg" wrote:

> On Wed, 24 May 2006 1002 -0700, kayabob wrote:
>
> > I have some fields where someone has used carriage returns with data entry.
> > Now, I need to export this data into a flat text file, and these carriage
> > returns are obviously messing up the record layout. Is there any way to
> > delete these carriage returns from my Access fields before I export to a text
> > file?
>
> If your version of Access supports the Replace Function, you can run
> an update query to replace all of the returns (with what?)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241
> This Update query replaces the returns with a single space.
> Use "" if you want to replace the returns with nothing.
>
> Back up your table first.
>
> Update YourTable Set YourTable.FieldName = Replace([FieldName],chr(13)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241
> & chr(10)," ");
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

Can you post the line(s) of code that you're using to do this,please.

"kayabob" wrote in message
news:37CDC8C5-88F0-4D18-8B12-D0D5D115D459@microsoft.com...
>I tried this but got a message: "6441 conversion failures due to type
> conversion". 6441 seems like it might be about the right # of carriage
> returns found. I was trying to replace the carriage return with 2 spaces.
>
> "fredg" wrote:
>
>> On Wed, 24 May 2006 1002 -0700, kayabob wrote:
>>
>> > I have some fields where someone has used carriage returns with data
>> > entry.
>> > Now, I need to export this data into a flat text file, and these
>> > carriage
>> > returns are obviously messing up the record layout. Is there any way
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241
>> > to
>> > delete these carriage returns from my Access fields before I export to
>> > a text
>> > file?
>>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10241
>> If your version of Access supports the Replace Function, you can run
>> an update query to replace all of the returns (with what?)
>> This Update query replaces the returns with a single space.
>> Use "" if you want to replace the returns with nothing.
>>
>> Back up your table first.
>>
>> Update YourTable Set YourTable.FieldName = Replace([FieldName],chr(13)
>> & chr(10)," ");
>> --
>> Fred
>> Please respond only to this newsgroup.
>> I do not reply to personal e-mail
>>