Make a Coding System for All Matrials

[stephanielue8088]

Make a coding system for all plumbing materials. Do this in the Water Flow Plumbing Code Draft sheet

Tip

If you want to easily extract the part number from the McMaster Link, Assuming that the link is in Cell A1 in Excel, and you want to put the part number in Cell A2:

=MID(A1,FIND("/",A1,9)+1,FIND("/",A1,FIND("/",A1,9)+1)-FIND("/",A1,9)-1)

FIND("/",A1,9) finds the position of the first "/" after the 9th character in the cell A1. The 9th character is where "https://" ends. This gives us the position of the first "/" after the domain.

FIND("/",A1,FIND("/",A1,9)+1) finds the position of the second "/" after the 9th character in the cell A1. This gives us the position of the second "/" after the domain.

MID(A1,FIND("/",A1,9)+1,FIND("/",A1,FIND("/",A1,9)+1)-FIND("/",A1,9)-1) extracts the text between these two "/" positions.

Caution

For the above to work, the part number MUST be between the two "/"

For example: https://www.mcmaster.com/91257A753 will give an error. Check that is it https://www.mcmaster.com/91257A753/