Power BI Reading a String to get Value

Hello, I am creating a dashboard for a constuction firm that has thousands of jobs, each of them with an 7 digit job number. The first number of all the job numbers is the same, and the next two numb...