Cut FQDN to host and domain

[#1]

Hi there again,

today I have a new Problem:

I have a list of FQDNs and paths, like:

//df020.sample.com/dfs/test$

test123.sample.com

new123.sample.com

//tf030.sample.com/new123

etc.

I need the hostnames standalone in a new field like test123, new123 but not the pathes.

Pathes can left blank in this new field.

I tried left, rigt, subfield, etc. but nothing really works.

Anybody an idea?

Thx in advance.

[#2]

Ahhh....this error was to easy to find....

There are some other tables with the same field and I only took one of the three.

Awkward for me. Sorry.

Now everything works with your formula,

Many thanks!!!!