Need to delete the last 13 characters of a field

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

 

[Douglas J. Steele]

Left([DataField], Len([DataField])-13)

 

[Ken Snell]

MyShorterString = Left([MyOriginalString], Len([MyOriginalString]) - 13)

 

[Guest]

Awesome! That did the trick. Thanks to both of you.

MyShorterString = Left([MyOriginalString], Len([MyOriginalString]) - 13)


--

Ken Snell
<MS ACCESS MVP>

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.