How to count whitespaces in the beggining of a string?

[catheprado]

Hello, i'm trying to count the number of white spaces in the beggining of a string in Power Query...

I couldn't find a solution yet.

Here's an example

I have to count just the whitespaces before the text. 

Please, help me 🙂 

Tks

[ziying35 · Accepted solution]

Hi, @catheprado 

Try this:

= Table.AddColumn(<YourPreviousStepName>, "space_cnt", each Text.Length([<YourColumnName>])-Text.Length(Text.TrimStart([<YourColumnName>])))