Extract Last Numeric Characters and a "-"

Add custom column as following:

List.First(
        List.RemoveNulls(
            List.Transform(
                Text.Split([FullString],"_"),
                each 
                    let x = try Number.FromText(_)
                    in if x[HasError] then null else _
            )
        )
    )

Steps:

1. Take FullString column and split it by _ into list

2. For each item in the list try to convert it into number
3. If transformations has error > give me null, else give me that value

4. Remove all nulls

5. Return fist item in the list