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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Need to do a comparison query based on a field with 13 or 12 chara 1
retrieve last three characters of field 2
Remove last character 1
Truncating a field in a table, need suggestions 5
Need to see everything in field except the last two characters 4
Instr parsing with a comma delimited string 3
Need to have a field always have 13 characters & insert leading ze 8

Back
Top