Converting a row to CSV (or MS Word)

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

Guest

Guys, I have a table row that is exported into access from a 3rd Party Prog
(FaultTree+). It is a concantenated string, the delimiters are characters
such as ~ ~* and . At each delimiter , I wish to force a lline break.
 
Hi Tim,

Use an update query to replace the delimiter characters with
Chr(13) & Chr(10)

e.g. to change both "~ ~" and "." to line breaks, update field XXX to

Replace(Replace([XXX], "~ ~", Chr(13) & Chr(10)), ".", Chr(13) &
Chr(10))
 
Back
Top