Parsing data using the RegEx tool

[Kyleellis21]

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.)?

[Manoj_k]

Hi @Kyleellis21 you can use \b([A-Z][a-z]{2})\b for the desired output 

[binu_acs]

@Kyleellis21 another options

[Kyleellis21]

Is there a way to do that with the RegEx tool?

[Kyleellis21]

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. 

[binu_acs]

@Kyleellis21