Getting rid of new line while inserting in .txt file

[times29]

Hi,
i have new lines for text field like below:

"My name is John

Sign-up here: - john.com

This is test message"

should be converted to

"My name is John Sign-up here: - john.com This is test message"

Is there a way way we can do while inserting to .txt and .ds file

Thanks

[ray.wurlod]

How do you know when "end of group" has occurred? For example, are there always three input lines that have to become one, or might there be two or four or some other number?

With that information more cogent advice may be possible.

[chulett]

I think this is one string field in a single record that has 'new lines' in it. If that's the case then you could use Convert() to either remove them or convert them to a space. Use CHAR(10) to represent the new line / line feed, for example.