This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How do I remove certain characters from a string if and only if they are that character? For example:
I have a column with NAICs 3 Digit Titles that have a "T" inserted at the end of some cells but not all. How do I remove the "T" from ONLY the end of the string IF and ONLY if it is a "T"? To clarify, If there is not a "T" at the end of the string I want the string to remain the same. Also, I do not want to replace every "T" just the ones at the end of the string.
NAICs 3 Digit Title Professional, Scientific, and Technical ServicesT Social AssistanceT Sporting Goods, Hobby, Musical Instrument, and Book Stores Real EstateT Food Services and Drinking PlacesT Specialty Trade ContractorsT Merchant Wholesalers, Nondurable Goods Furniture and Home Furnishings Stores Real EstateT
Here is how the Formula tool should be setup with "NAICs 3 Digit Title" being the field you modify. And you see with the Data Preview your value "Professional, Scientific, and Technical ServicesT" is changed to "Professional, Scientific, and Technical Services"
Here is how Formula tool should be placed in your workflow.