Extract last 4 characters ignoring leading from a field

[vimina]

I have a column in a table which is the combination of numeric and special charecters. I would like to extract last four charecters before the delimeter and ignore the leading 0 from it and populate the values to a new column. (Looking for a method to achieve this using M )

Sample Data:

As highligted with a color, there are cases when an extra special charecter appear in the data(can be because of human error), that should be corrected in the result.
SQL query used: LTRIM(RIGHT(SPLIT_PART(Column1, '-', 0), 4), 0) AS Desired Result (This query doesnt address 152-00003- values)

Any Help will be appreciated.
Thank You.

[Ahmedx]

it might be better that way!

[vimina]

Yes but for the values like (152-00003-) it should produce 3 as the result instead if 152

[Ahmedx]

if  List.Count(Text.Split([Column1],"-"))>2 then Number.FromText(Text.End(Text.BeforeDelimiter([Column1],"-",
    RelativePosition.FromEnd),4))
    else Number.FromText(Text.End(Text.BeforeDelimiter([Column1],"-",
    RelativePosition.FromStart),4))

[Ahmedx · Accepted solution]

Is this what you are looking for?

Number.FromText(
    Text.End(
    Text.BeforeDelimiter([Column1],"-",RelativePosition.FromStart),
    4)
    )