I have a month column that has each month fully spelled out. How would I either replace or parse that column by just keeping the first three letters of each month using the RegEx tool (ex. Jan, Feb, etc.)?
Hi @Kyleellis21 you can use \b([A-Z][a-z]{2})\b for the desired output
@Kyleellis21 another options
Is there a way to do that with the RegEx tool?
I'm having trouble getting it to work. I have done this before, I just forgot how to do it. I believe I started with \s when I correctly did it.