Converting line feed to tabs

[Jesse Aviles]

I have a table with over 300 records. There is a field
in those records
that contains line feeds. I want to separate that data
since I'm
redesigning the table and I'm not looking forward to do
this by hand. I
also want to send the fixed information to a text file.
TIA

 

[Marshall Barton]

I have a table with over 300 records. There is a field
in those records
that contains line feeds. I want to separate that data
since I'm
redesigning the table and I'm not looking forward to do
this by hand. I
also want to send the fixed information to a text file.

Use an Update query to replace the LF characters:

Update table Set afield = Replace(afield, Chr(10), Chr(9))

After the updates have been done, you can export the table
to a text file using File - SaveAs/Export menu item.

 

[Douglas J. Steele]

Just to tag onto Marsh's post, make sure first that all you have are LF
characters (Chr(10), or vbLf). Often, what you'll have is a CR/LF
combination (Chr(13) & Chr(10), or vbCrLf)

 

[Jesse Avilés]

Thanks


Jesse Avilés
(e-mail address removed)
Reply Only To The Newsgroup