Converting a row to CSV (or MS Word)

T

timarnold

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.
 
J

John Nurick

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))
 
Top