Cut last 5 character

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

Guest

Hi,
What function can we cut (trim) last 5 char in a string?
Ex: I am a student in CA
After cut=> I am a student
Thank you in advance.
MN
 
First make a backup copy of the table if you are updating the data.

Then use this ---
Left([YourField], Len([YourField]) -5)
 
Thank you - thank ..... How smart you are :-)
MN

KARL DEWEY said:
First make a backup copy of the table if you are updating the data.

Then use this ---
Left([YourField], Len([YourField]) -5)

--
KARL DEWEY
Build a little - Test a little


MN said:
Hi,
What function can we cut (trim) last 5 char in a string?
Ex: I am a student in CA
After cut=> I am a student
Thank you in advance.
MN
Click to expand...
Click to expand...
 
Back
Top