SPLITBYCASETRANSITION

[lrobbo314]

SPLITBYCASETRANSITION will split text by case transition from lower case to upper case.

SPLITBYCASE
=LAMBDA(text,
    LET(
        t,text,
        x,REDUCE(t,SLEN(t),
            LAMBDA(s,c,
                IF(AND(ISLOWER(MID(s,c,1)),ISUPPER(MID(s,c+1,1))),
                s&","&c,
                s)
            )
        ),
        ct,TEXTSPLIT(RIGHT(x,LEN(x)-LEN(t)-1),,",")+1,
        r,ct+SEQUENCE(ROWS(ct),,0),
            REDUCE(t,r,LAMBDA(s,c,REPLACE(s,c,0," ")))
    )
)

SPLITBYCASETRANSITION
	A
1	TheQuickBrownFoxJumpsOverTheLazyDog
2
3	The Quick Brown Fox Jumps Over The Lazy Dog
Sheet1

Cell Formulas
Range	Formula
A3	A3	=SPLITCASETRANSITION(A1)

 

[steven88]

 

[lrobbo314]

Forgot helpers again.

ISLOWER

=LAMBDA(char,LET(c,CODE(char),AND(c>96,c<123)))

ISUPPER

=LAMBDA(char,LET(c,CODE(char),AND(c>64,c<91)))

SLEN

=LAMBDA(text,SEQUENCE(LEN(text)))

 

[Xlambda]

Hi again, with your permission, this is also a good example for algorithm awareness, this time, how to analyze diffrent algorithms complexities. ( Big O notation) .Lower is always better and faster.
For a single element, your function uses 2 REDUCE, therefore, for an entire array you will need another LHF (lambda helper function), a MAP.
This means that the Big O will be O(n^3) where n is the nr. of array's elements.
Alternative solution, a function of complexity O(26) , => lot less complex, only 26 iterations, no matter the array size:
UPPSP(a) Upper Space

=LAMBDA(a,TRIM(REDUCE(a,CHAR(SEQUENCE(26,,65)),LAMBDA(v,i,SUBSTITUTE(v,i," "&i)))))

Hint: In general, a char "x" is a letter if =EXACT(LOWER(x),UPPER(x)) returns FALSE

Book1.xlsx
	A	B	C	D	E	F	G
1					calc time instant: for 100k elements
2		=IF(SEQUENCE(50000,2),"TheQuickBrownFoxJumpsOverTheLazyDog")			=UPPSP(B3#)
3		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
4		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
5		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
6		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
7		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
8		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
9		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
10		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
11		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
12		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
13		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
14		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
15		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
16		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
17		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
18		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
19		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
20		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
21		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
22		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
23		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
24		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
25		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
26		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
27		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
28		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
29		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
30		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
31		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
32		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
33		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
34		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
35		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
36		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
37		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
38		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
39		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
40		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
41		TheQuickBrownFoxJumpsOverTheLazyDog	TheQuickBrownFoxJumpsOverTheLazyDog		The Quick Brown Fox Jumps Over The Lazy Dog	The Quick Brown Fox Jumps Over The Lazy Dog
Sheet2

Cell Formulas
Range	Formula
B2,E2	B2	=FORMULATEXT(B3)
B3:C50002	B3	=IF(SEQUENCE(50000,2),"TheQuickBrownFoxJumpsOverTheLazyDog")
E3:F50002	E3	=UPPSP(B3#)
Dynamic array formulas.