topic Formula to strip off letters in a column not working in Alteryx Designer Desktop Discussions

Formula to strip off letters in a column not working

MikeFrancis1959 — Tue, 23 May 2023 18:38:40 GMT

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

Re: Formula to strip off letters in a column not working

ChrisTX — Tue, 23 May 2023 18:42:17 GMT

Try

THEN Trim(Replace([2nd GI], "ETA", ""))

Re: Formula to strip off letters in a column not working

MikeFrancis1959 — Tue, 23 May 2023 18:51:57 GMT

it did not strip of the ETA

Mike

Re: Formula to strip off letters in a column not working

ChrisTX — Tue, 23 May 2023 19:15:44 GMT

Maybe something above the ELSEIF is being executed? Can you send sample input data and the full IF statement?

Re: Formula to strip off letters in a column not working

MikeFrancis1959 — Tue, 23 May 2023 19:37:55 GMT

I highlighted the formula with a comment box that is red

Thanks,

Mike

Re: Formula to strip off letters in a column not working

nagakavyasri — Tue, 23 May 2023 19:42:04 GMT

if ETA is in same position throughout the column, then try this

Re: Formula to strip off letters in a column not working

ChrisTX — Tue, 23 May 2023 19:46:58 GMT

The YXMD file doesn't include your input XLSX file. Need to use the menu... Options > Export Workflow to create a YXZP file.

Re: Formula to strip off letters in a column not working

MikeFrancis1959 — Tue, 23 May 2023 19:55:53 GMT

Try this

Re: Formula to strip off letters in a column not working

nagakavyasri — Tue, 23 May 2023 20:07:44 GMT

The condition is satisfied in 1st IF statement, so it is not going to further Elseif conditions. The 1st condition says !isempty[2nd GI], as the [2nd GI] is not empty, the same is returned.

Try changing the 1st condition so that Contains function works, like this:

Re: Formula to strip off letters in a column not working

MikeFrancis1959 — Tue, 23 May 2023 20:10:58 GMT

I am not sure what part of the formula to change, can you show me what you mean?

Mike

Re: Formula to strip off letters in a column not working

nagakavyasri — Tue, 23 May 2023 20:28:15 GMT

Highlighted in this:

Re: Formula to strip off letters in a column not working

MikeFrancis1959 — Tue, 23 May 2023 20:29:26 GMT

OK, I see what you mean!

Thanks,

Mike