10 Replies Latest reply: Nov 16, 2016 4:14 AM by Walter Mining RSS

    Cut FQDN to host and domain

    Walter Mining

      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.