I need to drop the first and last character of each field entry..

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

Guest

I am importing a text file that has a "<" at the beginning and a ">" at the
end of each data field. The field lengths vary from 4 characters to 50
characters. I need to find a way to clean up the beginning and ending
character of each.

Can you help??
 
Hi,

strTest = Mid(yourfield, 1, Len(yourfield) - 2)

That should do it...
 
Stephanie,

You can use an Update Query for this. Make a query based on the
imported table, make it an Update Query (select Update from the Query
menu in query design), and in the Update To row of the grid, for all of
the affected fields, put the equivalent of:
Mid([NameOfField],2,Len([NameOfField])-2)
Run the update query (try it on a backup copy first!)
 
Back
Top