Help with output from import-csv and -join / replace

-

i'm having trouble in getting correct output following script.

foreach ($line in import-csv c:\computers.csv)  {  $computer = $line.computer  $a = $line.info  $b = -join "$line.computer".replace("-","")[0,1,-2,-1]  $computer  $a  $b  }

the .csv file has computer name of "abc-testcomp01" in column "a" , "someinfo" in column "b"

$computer returns "abc-testcomp" correctly

$a returns "someinfo"

$b returns "@{er"

however @ console

-join "abc-testcomp".replace("-","")[0,1,-2,-1]  returns correctly with "abmp"

how can correct value returned $b

monday, january 14, 2013 8:36 pm
|

$b = -join "$($line.computer)".replace("-","")[0,1,-2,-1]

try encasing $line.computer in $(), value of $line.computer first, return string expanded in double quotes $()

or have done 

$b = -join "$computer".replace("-","")[0,1,-2,-1]

seeing added value of $line.computer $computer

if find post has answered question, please mark answer. if find post helpful in anyway, please click vote helpful.




Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Error: 0x80073701 when trying to add Print Services Role in Windows 2012 Standard

-
hello, i'm getting error when trying add print services role in windows 2012 standard. i'm getting same error whether use gui or powershell. this new server install. the powershell error follows: add-windowsfeature : request add or remove features on specified server failed. installation of 1 or more roles, role services, or features failed. the referenced assembly not found. error: 0x80073701 at line:1 char:1 + add-windowsfeature print-services + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : invalidoperation: (@{vhd=; credent...name=localhost}:psobject) [install-windowsfeature],     exception     + fullyqualifiederrorid : dismapi_error__failed_to_enable_updates,microsoft.windows.servermanager.commands.addwind    owsfeaturecommand success restart needed exit code      feature result ------- ------...
Read more

difference between wuauclt1.exe and wuauclt.exe

-
what difference between wuauclt1.exe , wuauclt.exe files ( under system32 folder ) ? in of cases, windows update service is not working client machines having these 2 files. even tried delete wuauclt1.exe, created automatically. what difference between wuauclt1.exe , wuauclt.exe files ( under system32 folder ) ? the wuauclt1.exe (and sister file wuaueng1.dll) components of legacy au agent shipped operating systems released prior 2005. (the wuagent v5.8 shipped wsus v2 in spring, 2005.) checking file version of file on windows xp system shows 5.4.3790.5512, dated 4/14/2008. additional quirk surrounds particular version -- comes installation of windows xp service pack 3. on windows server 2003 or windows 2000 system, may have earlier version number , date. lawrence garvin, m.s., mcitp:ea, mcdba, mcsa product manager, solarwinds microsoft mvp - software distribution (2005-2012) mvp profile: http://mvp.support.microsoft.com/profile/lawrence.garvin ...
Read more

Windows 2016 RDS event 1306 Connection Broker Client failed to redirect the user... Error: NULL

-
Image
i'm attempting setup windows 2016 rds standard deployment session hosting.  layout follows: rds01 - rds connection broker , web access ts02 - rds session host ts03 - rds session host domain these servers part of has (1) windows 2008 server , (2) windows 2016 servers acting dcs.  domain running @ windows 2003 functional level. servers on single routed network no firewall between them.  dns , ptr records servers exist , resolve on hosts.  servers can pinged each other. in other words, there no network connectivity issues. i've setup rds deployment several times w/ same results. the issue can login via rdweb interface on rds01 win10 desktop , connect published rdp desktop without issue (i.e. no error messages user) , no errors in logs.  when try directly rdp rds01, authenticate user (per event log) error stating user doesn't have access system.  in event log event id 1306 message of "remote desktop connection broker client faile...
Read more