Need to delete the last 13 characters of a field

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

Guest

I have a table with about 28,000 records and I need to cut off the last 13
characters of a field. There is no consistency with the data up to that 13th
character, so the left and right commands are not getting it done. Is there a
query I can run that will trim off the final 13 characters of the field and
return everything else?

Any help on this would be greatly appreciated.
 
Awesome! That did the trick. Thanks to both of you.

Ken Snell said:
MyShorterString = Left([MyOriginalString], Len([MyOriginalString]) - 13)


--

Ken Snell
<MS ACCESS MVP>

SW Data said:
I have a table with about 28,000 records and I need to cut off the last 13
characters of a field. There is no consistency with the data up to that 13th
character, so the left and right commands are not getting it done. Is there a
query I can run that will trim off the final 13 characters of the field and
return everything else?

Any help on this would be greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top