Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trim a field

Status
Not open for further replies.
Moxy1

Moxy1

Programmer
Aug 29, 2002
75
US
I have data in a field with an inconsistent length. At the end of each item is the word "Day". What is the best way to trim out the word Day?

Moxy
 
Sort by date Sort by votes
If "Day" is always at the end then
Code: 
   myStr = Left ( myStr, Len(myStr)-3 )
If only some of the strings contain "Day" at the end then
Code: 
   myStr = IIF (Right(myStr,3)="Day",
                Left ( myStr, Len(myStr)-3 ),
                myStr )
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
3K
TrekBiker
TrekBiker
raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
487
dhookom
dhookom
monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
375
dhookom
dhookom
ameedoo3000
  • Locked
  • Question
Send a message to an email
Replies
2
Views
2K
ameedoo3000
ameedoo3000
TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
469
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top