We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula to strip off letters in a column not working

MikeFrancis1959
8 - Asteroid

I have formula (see below) that is part of a larger set of formulas but the formula below is not doing what I wanted it to do, I have a column with that has a date with the letters ETA with it like 

ETA 05/26/23   and I just want to strip off the "ETA" and just leave 05/26/23 but it stays the same ETA 05/26/23 and nothing gets stripped off . I tried replacing the formula with "Left" and nothing changes either and I know it is something simple but I cannot figure out what it is, can someone help?

Thanks,

Mike

 

ELSEIF Contains([2nd GI],"ETA")
THEN Right(Replace([2nd GI], "ETA", ""),5)

 

example ETA 0526/23

Want it to be  05/26/23

11 REPLIES 11
nagakavyasri
12 - Quasar

Highlighted in this:

 

Screenshot 2023-05-23 160656.png

MikeFrancis1959
8 - Asteroid

OK, I see what you mean!

Thanks,

Mike

Labels
Top Solution Authors