search

usfsoar / torito-23-24

This is a repo for the USF Soar Torito division's repositories.
1 stars 1 forks source link

Make a Coding System for All Matrials #54

Open stephanielue8088 opened 6 months ago

stephanielue8088 commented 6 months ago

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/