Extract Text Based on Length of String

[Alex03260]

I have text in a column "Outline_Number" I want to extract some of the text based on the length of the string to a new column "Outline_Parent"

i.e. I want the whole string minus the last 2 characters, this would be easy in excel but i'm relatively new to BI.

"Outline_Number" = 1.1.2.2.4

Result

"Outline_Parent" = 1.1.2.2

Thanks 

Alex

[AlienSx]

Text.Combine(List.RemoveLastN(Text.ToList(txt), 2))

[Vijay_A_Verma]

You may use this

Text.Start([Outline_Number],Text.Length([Outline_Number])-2)

If you have string less than 2 in length

then

try Text.Start([Outline_Number],Text.Length([Outline_Number])-2) otherwise null

[Alex03260]

The first version worked but as expected gives an error on short string, the 2nd version gives a syntax error on the "otherwise null"