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 Chriss Miller 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
Joined
Aug 29, 2002
Messages
75
Location
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 Question
Field size limit Access 365
Replies
5
Views
6K
TrekBiker
TrekBiker
raywood1
  • Locked
  • Question Question
Reducing a Massive Linked Table
Replies
4
Views
1K
dhookom
dhookom
monkeysee
  • Locked
  • Question Question
Field to count specific records
Replies
3
Views
916
dhookom
dhookom
ameedoo3000
  • Locked
  • Question Question
Send a message to an email
Replies
2
Views
5K
ameedoo3000
ameedoo3000
TrekBiker
  • Locked
  • Question Question
Using old IDs as Autonumbers
Replies
6
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top