Power Query: Izdvajanje brojeva iz tekstualnog niza

Funkcija: Izdvaja samo numeričke vrijednosti iz datog teksta. Jednostavno dodajte prilagođenu funkciju u Power Query i definirajte svoju kolonu.

Add a new Query from Sources

Upotreba:

 = ExtractNumbers("Order ID: 123ABC456") → Returns: "123456"

Power Query kod za upotrebu i ponovnu upotrebu:

let

    ExtractNumbers = (inputText as text) as text =>

    let

        NumbersOnly = Text.Select(inputText, {"0".."9"})

    in

        NumbersOnly

in

    ExtractNumbers

Choose your column with a text/number to clean (to extract just numbers)

Trebate kod i upute? Besplatno =)

pq_ExtractNumbersFromString.txt

Download TXT • 1KB

If you found this guide useful, explore the related posts below or download a free Power Query cheat sheet by subscribing to the Excelized newsletter.

👉 Ready to stop cleaning data manually? Book a live 1:1 Power Query Beginner Bootcamp and master it hands-on with me.