Trimming Folder Path of a Url Without Losing First Folder

[mywebguytaylor1]

When the case "the case when the domain is "es-la.domain.com/peter.75054"

With this formula below, everything is correct

=ArrayFormula(IFERROR(REGEXEXTRACT(A1:A,"\w+.\w+/\w+")))


YES, GREAT! HOWEVER< THERE IS ONE LAST PROBLEM:

What if the folder has a period in the folder name...such as the case of: "the case when the domain is "es-la.domain.com/peter.75054"

Do you see how there is a period in between peter "." 75054 ?

This throws the formula off. The output of the formula is not correct, it defers the output to an incorrect folder

[mywebguytaylor1]

Do you know how to fix this?

I need someone who understand how to make that final fix, because the person who helped me this far is not available anymore.

This did not work

=ArrayFormula(IFERROR(REGEXEXTRACT(A1:A,"^([^\/]*\/[^\/]*)")))

[mywebguytaylor1]

screenshot3514eA3.png

This board will not let me post links, so I am trying this as an image.

[mywebguytaylor1]

I am not able to post links, so I am trying to post this as an image.

If there is anyone here who can help me with this simple formula fix, please help! I am working on a major deadline and need this asap.

Attachment 724954