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.
I have a column in my data set that looks like below and I want to keep only the characters right to the "-". I wanted to use formula tool and the trim function to do this, but I do not have enough experience to apply my logic. Can anyone help? Thanks in advance!
Here's an updated example that adds the Formula tool. I've enumerated steps to produce columns that show the length of the string, the character position of the "-", and operations to grab the desired characters. This is a bit over-kill, but it might help you understand some of the possibilities. You should tool the methodology that best fits your data.
@EstherB47 great suggestions as well. I posted another example that uses string operations logic. It's similar to your suggestion. RegEx is probably the most powerful, but it can be intimidating for those new to it (and to those who have some experience with it!).
@BenBothanks for sharing, it worked! I actually had more than 1 "-" and I needed to parse out the characters after the last "-" occurence. So I applied your formula 2 times for those fields using a IF statement.