Announcing New Text and Array Functions

Excel Team -When it rains it pours !!! -  This is simply Brilliant - Cant wait till it comes to the Current Channel Preview

Couple of suggestions

TEXTBEFORE and TEXTAFTER can have optional parameters viz. No of Delimiters to Skip and Direction

This would then become similar to the PQ functions

Text.Before(After)Delimiter(text,dl,{2,RelativePositon.FromStart}) 

So TEXTBEFORE(txt,dl,2,0) or TEXTBEFORE(txt,dl,2,1) 

VSTACK/HSTACK - Just perfect !

So now we can put the Header Row of the Data on top of the Array returned by the FILTER Function

VSTACK(D[#Headers],FILTER(D,D[Name]="BRUCE"))

HSTACK - is just revolutionary - I mean VSTACK has equivalents in s Table.Combine or UNION- But there is just no easy way to do what HSTACK is doing in PQ or SQL

TEXTSPLIT - The ability to split with multiple delimiters per row and column is wonderful - a much much awaited function.

The rest of them are also going to revolutionize the the ability to handle arrays

Cheers

Sam

[Edit]: These functions just rolled out for me yesterday - TEXTBEFORE/TEXTAFTER  does have an Instance number parameter and a negative sign indicates from end of string !!! - Great