Text Selection/Manipulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Brett said:
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?
Click to expand...


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

textfield: Replace(textfield, Chr(13) & Chr(10), "~~~")
 
Thanks. I'll give that a try

Marshall Barton said:
You can replace the new line sequence with a different
sequence of characters. E.g.

textfield: Replace(textfield, Chr(13) & Chr(10), "~~~")
Click to expand...
 
Back
Top