Delete carriage returns

[Guest]

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?

 

[fredg]

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?)
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)," ");

 

[fredg]

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?)
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)," ");

 

[Guest]

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.

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?)
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)," ");

 

[Guest]

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.

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?)
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)," ");

 

[Rick Wannall]

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

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.

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?)
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)," ");

 

[Rick Wannall]

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

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.

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?)
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)," ");