Here is an example of the ask:
Column 1(data) Column 2(what the goal is)
lskadjf/5/kdjlj 5
kldjfl/8/lkjd 8
oieurow/10/lksajl 10
sldkjfjl (blank)
kjsdflj/dsjjfl (blank)
lkdjflk/lkj (blank)
Is there a way to do this?
You can use the Text.BetweenDelimiters function.
Text.BetweenDelimiters([Column 1], "/", "/")
The GUI works fine for this. Just put / in both boxes.
If you want to check that there are exactly two slashes, try this:
if Text.Select([Column1], {"/"}) = "//"
then Text.BetweenDelimiters([Column1], "/", "/")
else null