In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Parsing data using the RegEx tool

Kyleellis21
5 - Atom

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

5 REPLIES 5
Manoj_k
9 - Comet

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

binuacs
21 - Polaris

@Kyleellis21 another options

image.png

Kyleellis21
5 - Atom

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

Kyleellis21
5 - Atom

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. 

binuacs
21 - Polaris
Labels
Top Solution Authors