Any alternative for the TEXTLIST() function?
The use of the TEXTLIST() is not a best practice. However, as I go through the Anapedia, Planual and forum threads I haven't seen the alternative for that. There are some forum threads that provide ANY, FIRSTNONBLACK, LASTNONBLACK as alternatives for the TEXTLIST, which is aggregation function. But I need alternative to the TEXTLIST() function, which is a TEXT function, not an aggregation function.
I'd appreciate your replies? Thanks in advance.