Forum Discussion

DAM_ELK's avatar
DAM_ELK
Copper Contributor
Nov 13, 2023

Extracting part of a text string

I'm trying to extract a discrete part of a text string -- a number before a certain delimiter, in this case, "%". The string is all text except the number(s) that precede the percentage sign. I want...
BI & Data Analysis
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 13, 2023

DAM_ELK 

A 365 solution that be can be used on a vector:

=LET(
    KeepNumbers, LAMBDA(string,
        LET(
            explode, TOCOL(MID(string, SEQUENCE(LEN(string)), 1) * 1, 2),
            IFERROR(CONCAT(explode) * 1, "")
        )
    ),
    BYROW(array, KeepNumbers)
)

 

Resources