Use awk or sed to capture & parsing text

Question

I've some text output like the following:

+-------------------------+-----+--------------------------------+--------------------------------------------+
| Site                    | SSL | URL                            | Path                                       |
+-------------------------+-----+--------------------------------+--------------------------------------------+
| samplerds.test          |     | http://samplerds.test          | /Users/user01/Paths/samplexx1              |
| wpo.test                |     | http://wpo.test                | /Users/user01/Paths/wpo                    |
+-------------------------+-----+--------------------------------+--------------------------------------------+

Is there any way to parsing the text above using awk or sed to transform them into the following:

samplerds
wpo

Cheers

Answer 1

Use awk:

$ awk -F '[ .]' 'NR>3 && !/^\+/ {print $2}' file
samplerds
wpo

or add the subdomain as field separator:

awk -F ' |\.test' 'NR>3 && !/^\+/ {print $2}' file

or with gsub to make it also work when you have subdomains:

awk 'NR>3 && !/^\+/ {gsub("\.[^.]*$","",$2); print $2}' file