When i input data I end up with a file name column that looks like this:
| File Name |
| Test Name Date ID# Wafer and Device ID1 #ID comment |
| Test Name Date ID# Wafer and Device ID2 #ID different comment |
| Different Test Name Date ID# Wafer and Device ID1 #ID comment |
| Different Test Name Date ID# Wafer and Device ID2 #ID different comment |
What I want is the following:
| File Name |
| Wafer and Device ID1 |
| Wafer and Device ID2 |
| Wafer and Device ID1 |
| Wafer and Device ID2 |
All of these have different delimiters and string lengths, what I want to do is extract the Wafer and Device ID from with the '#' characters minus the spaces. I'm finding a lot of information on taking out a specific number of characters, but I am struggling to find any information on searching a string and removing "# " from the left and " #" from the right and leaving the string in the middle.
Thank you in advance for your assistance.
