How to copy between 2 strings

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?

Workflow

Accepted answers

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 😀👍

All comments

Use regex tool parse mode

IP:   (.*) user

It's coming out empty 😕

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 the regEx below

Attached the workflow 🙂

Hope that helps!

Regards,

RegEx IpAddress.yxmd

not working, there are also other numbers, characters in that same row.

All I want is the IP address that is between the word: ip: and user and drop every other character or number

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703