Choose-Evaluate-Let?

[serp]

How can I make a simple formula in order to get abreviations from a field ("Task_days") with all week days?

I was trying to made it with Let & Choose

[-Queue-]

Let( A = Substitute( Filter( Lower(task_days); "adefhimnorstuwy" ); ["sunday"; "SU-"]; ["monday"; "MO-"]; ["tuesday"; "TU-"]; ["wednesday"; "WE-"]; ["thursday"; "TH-"]; ["friday"; "FR-"]; ["saturday"; "SA-"] );

Left( A; Length(A) - 1 )

)

[Ender]

"adefhimnorstuwy"

Making up words again, Queue? Looks kind of like anagram material. How about:

"DamWishyFortune"

[serp]

Let( A = Substitute( Filter( Lower(task_days); "adefhimnorstuwy" ); ["sunday"; "SU-"]; ["monday"; "MO-"]; ["tuesday"; "TU-"]; ["wednesday"; "WE-"]; ["thursday"; "TH-"]; ["friday"; "FR-"]; ["saturday"; "SA-"] );

Left( A; Length(A) - 1 )

)

Perfect

[comment]

Try:

Let (

A= Substitute (

FilterValues ( "lunes