Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing #13#10 from memo field

Status
Not open for further replies.
Filer

Filer

MIS
Jun 19, 2002
5
US
I am trying to copy from a memo field in an Interbase table to a memo field in a Paradox DOS table. Using an insertrecord command copies the data correctly except that the #13#10 is copied as well. This shows up as a music note at the end of every memo entry.

I have tried other methods to strip these characters, but run into problems with data type conversions and only copying the first 255 characters.

Is there an easy way to correct this?

Any help is greatly appreciated
 
Status
Not open for further replies.

Similar threads

stratao
  • Locked
  • Question
trying to read DB.ID from another computer
Replies
0
Views
116
stratao
stratao
Elroacho
  • Locked
  • Question
Max from union
Replies
0
Views
112
Elroacho
Elroacho
fredycc
  • Locked
  • Question
Problem "Attempted to read or write protected memory." with Delphi
Replies
0
Views
104
fredycc
fredycc
bob1660
  • Locked
  • Question
Display the content of a BLOB field
Replies
1
Views
87
unclejimbob
unclejimbob
tonytoney
  • Locked
  • Question
Removing Duplicate Rows
Replies
1
Views
62
bmarks
bmarks

Part and Inventory Search

Sponsor

Back
Top