TEXTSPLIT combined with BYROW returns an unexpected result when using an array of strings as input

Question

I have the following formula:&nbsp;&nbsp;=LET(input, {"a,b;c,d;" ; "e,f;g,h;"}, 
  BYROW(input, LAMBDA(item, TEXTJOIN(";",,TEXTSPLIT(item,",",";", TRUE)))))&nbsp;&nbsp;&nbsp;expecting the get the input back but without the last semi-colon. Instead, I am getting the following array: {a;e}. If I replace BYROW with MAP, it works. Similarly if I use a range for input it works with BYROW.&nbsp;&nbsp;I think it is a possible bug, if so, was it reported, and where I can track the process of the solution?&nbsp;Thanks,&nbsp;David

sergeibaklan · Answer

davidleal&nbsp;
Perhaps this&nbsp;https://techcommunity.microsoft.com/t5/excel/byrow-function-produces-two-different-results-depending-on/m-p/3679875/highlight/false#M171199&nbsp;discussion helps.
&nbsp;
BYROW() passes to lambda item as an array from one element, and MAP() - value. If you use&nbsp;@item in BYROW it shall work, didn't test.

Forum Discussion

TEXTSPLIT combined with BYROW returns an unexpected result when using an array of strings as input

Resources