Question How to remove line breaks from a table? (1 Viewer)

mark_m

New member
Local time
Today, 20:00
Joined
Feb 23, 2009
Messages
2
Hello!

I am doing a merge from Access to InDesign, and I have a problem where the line breaks in a form field - which have been inserted by users with a carriage return - are each treated by InDesign as a seperate field.

How can I remove these line breaks /carriage returns from the table?

I am not an expert Access user....

Thanks in anticipation

Mark
 

Guus2005

AWF VIP
Local time
Today, 21:00
Joined
Jun 26, 2007
Messages
2,553
you could use the replace function to replace newline characters to spaces.

Before sending the records to InDesign(?) run an update query on the table in question.

Code:
update table1 set Field1 = replace([Field1], chr(10), " ")
You could do the same with chr(13)

HTH:D
 

mark_m

New member
Local time
Today, 20:00
Joined
Feb 23, 2009
Messages
2
Thanks Guus, I think that did the trick!
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom