sdaaish/2.csv

## 2.csv

          
            System
            Ip
            Type
            Other

            
              dev.idg.se
              1.1.1.1
              Ubuntu
               Development

            
              hr.dn.se
              2.2.2.2
              Debian
               Human Resources

            
              www.gp.se
              3.3.3.3
              FreeBsd
               Front web site

## 2.ps1
[cmdletbinding()]
Param (
    [Parameter(Mandatory)]
    $Path
)
$csv = import-csv $Path

$csv|Add-Member -NotePropertyName ShortHost -NotePropertyValue ''

$collection = @()
foreach($i in $csv){
    $i.shorthost = ($i.system).split(".")[0]
    $collection += $i
}
$collection|select-object System,ShortHost,Ip,Type,Other
System	Ip	Type	Other
dev.idg.se	1.1.1.1	Ubuntu	Development
hr.dn.se	2.2.2.2	Debian	Human Resources
www.gp.se	3.3.3.3	FreeBsd	Front web site
	[cmdletbinding()]
	Param (
	[Parameter(Mandatory)]
	$Path
	)
	$csv = import-csv $Path

	$csv\|Add-Member -NotePropertyName ShortHost -NotePropertyValue ''

	$collection = @()
	foreach($i in $csv){
	$i.shorthost = ($i.system).split(".")[0]
	$collection += $i
	}
	$collection\|select-object System,ShortHost,Ip,Type,Other