Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!!!!