Need to delete the last 13 characters of a field

S

SW Data

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.
 
S

SW Data

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...
 
Top