You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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/
The text was updated successfully, but these errors were encountered:
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 ithttps://www.mcmaster.com/91257A753/
The text was updated successfully, but these errors were encountered: