Forum Discussion
Search for Word in String, bring back Word +
Hello, I'm trying to look in [Column] for the word "Scenario". If it finds it, I need to return "Scenario " + the next 2 characters. For example, the string may read "2040 3m Scenario 1 **DO NOT CHANGE**" and I need to return "Scenario 1"
Actually, I'll just look for Text.Contains "Scenario 1" or "Scenario 2" etc. That should do what I need, too. Sorry to bother!
Hi,
from this
to achieve this
you have to add a custom column
Text.Range([Column1], Text.PositionOf([Column1],"Scenario"),10)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
3 Replies
Hi,
from this
to achieve this
you have to add a custom column
Text.Range([Column1], Text.PositionOf([Column1],"Scenario"),10)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
That's perfect! Thanks so much for figuring this out for me!!
Actually, I'll just look for Text.Contains "Scenario 1" or "Scenario 2" etc. That should do what I need, too. Sorry to bother!