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