Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-01-2018, 02:49 PM
jon.fallows@sedgman.com jon.fallows@sedgman.com is offline strip characters from the right Windows 7 64bit strip characters from the right Office 2010 64bit
Novice
strip characters from the right
 
Join Date: May 2018
Location: Australia
Posts: 2
jon.fallows@sedgman.com is on a distinguished road
Default strip characters from the right

I need to strip (and not keep) characters from the right of a list of irregular strings. For example, in this string;

SCR SC207 MC3001 4W FIRE SUPP & EXT INSP STAT Rev 0';

I need to strip 'Rev 0' and retain the rest.

Note that strings in the list may NOT be all the same length.

I can strip from the left, but the right is proving to be tricky.



Thanks
Jon
Reply With Quote
 

Tags
string

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
strip characters from the right Format shelf strip graphic and data ShaunO Mail Merge 1 08-19-2016 04:20 PM
Strange Characters appear when selecting SHOW ALL NON PRINTING CHARACTERS ann Amber Word 1 08-01-2015 08:06 PM
strip characters from the right strip extra information from email addresses jbk1043 Word 1 03-03-2013 01:46 PM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM
strip characters from the right Strip lf/cr from text p3aul Word 9 08-18-2009 12:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft