Text Selection/Manipulation

[Brett S.]

I need to create an export to an .asc file for purposes of importing existing
data into a new system. I've pulled the data into an Access DB to manipulate
it, then export it to the .asc file. One of the fields is a text field. Some
of the records include a carriage return in the field, so when I export the
record shows up on multiple lines in the .asc file. This causes problems when
I attempt the import of this file.

Can anyone offer suggestions of how I can write VB or SQL code to solve this
problem?
Thanks

 

[Marshall Barton]

I need to create an export to an .asc file for purposes of importing existing
data into a new system. I've pulled the data into an Access DB to manipulate
it, then export it to the .asc file. One of the fields is a text field. Some
of the records include a carriage return in the field, so when I export the
record shows up on multiple lines in the .asc file. This causes problems when
I attempt the import of this file.

Can anyone offer suggestions of how I can write VB or SQL code to solve this
problem?

You can replace the new line sequence with a different
sequence of characters. E.g.

textfield: Replace(textfield, Chr(13) & Chr(10), "~~~")

 

[Brett S.]

Thanks. I'll give that a try

You can replace the new line sequence with a different
sequence of characters. E.g.

textfield: Replace(textfield, Chr(13) & Chr(10), "~~~")