How to copy between 2 strings

[soncoku]

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? 

[atcodedog05]

Hi @soncoku 

Use regex tool parse mode

IP:   (.*) user

[soncoku]

It's  coming out empty 😕

@atcodedog05 

[atcodedog05 · Accepted 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 😀👍

[atcodedog05]

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.

[soncoku]

http://www.xwebsite.net/<br>ip: 192.168.1.130 user: user222 password: passss@w port: 21

@atcodedog05 

[atcodedog05]

@soncoku 

The data is totally different here is the updated workflow.

You can use one of them

[soncoku]

@atcodedog05  the formula works . Thanks 🙂

[atcodedog05]

Happy to help 🙂 @soncoku 

Cheers and Happy Analyzing 😀

[messi007]

Dear @soncoku,

Please check the regEx below

Attached the workflow 🙂

Hope that helps!

Regards,