Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Change month name in text field

ppatane
8 - Asteroid

How can I change the month name in a description to the next month? In this example, get all the April words to be May, and have it work every month.

2024-05-30_15-22-04.jpg

3 REPLIES 3
Raj
16 - Nebula

@ppatane one way is writing a formula with multiple iffs and elseifs
another way is using Find and replace tool.

binuacs
21 - Polaris

@ppatane one way of doing this

image.png

ppatane
8 - Asteroid

Wow, incredibly complex Regex statement, and it even goes forward a year for December to January.  Perfect!  Grazie!

Labels
Top Solution Authors