Hey everyone
I have a column where each row has :
a link , and IP a username a password and port number
they are only separated by spaces
I need a regex formula that would copy the text between these 2 exact words:
IP: xx.xx.xx.xxx user
everything that is between IP and user.
Any ideas?
Solved! Go to Solution.
Hi @soncoku
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Please check this if also doesnt work. Please share a sample of the data 1 or 2 ips. You can mask 1or2 numbers in them.
http://www.xwebsite.net/<br>ip: 192.168.1.130 user: user222 password: passss@w port: 21
@atcodedog05 the formula works . Thanks 🙂