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

New Contributor

I have the following formula:

 

 

=LET(input, {"a,b;c,d;" ; "e,f;g,h;"}, 
  BYROW(input, LAMBDA(item, TEXTJOIN(";",,TEXTSPLIT(item,",",";", TRUE)))))

 

 

 

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. 

 

I think it is a possible bug, if so, was it reported, and where I can track the process of the solution?

 

Thanks,

 

David

1 Reply

@davidleal 

Perhaps this https://techcommunity.microsoft.com/t5/excel/byrow-function-produces-two-different-results-depending... discussion helps.

 

BYROW() passes to lambda item as an array from one element, and MAP() - value. If you use @item in BYROW it shall work, didn't test.