Converting line feed to tabs

  • Thread starter Thread starter Jesse Aviles
  • Start date Start date
J

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


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.
 
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)
 
Thanks


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