Powershell importing a CSV file

-

beginner in powershell,

question: have csv file have imported. csv has a number of values in each cell. want know how can parse through data want.

example csv file:

samaccountname title department
user1 tester/worker/$$$/msn accounting
user2 developer/$ technical
user3 programer/thomas pre-sales

i powershell code go through entire csv , provide output of: 

samaccountname title department
user1 worker accounting
user2 developer technical
user3 programer pre-sales

not clear on how can parse data, appreciated!

at first glance, looked wanted before first "/" in title column, not true of user1 based on example.  logic need use provide data looking for?


Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

directory stack

-
witchcraft>> $algo -eq $null true witchcraft>> cd $algo.key # directory stack: --- ---------------- 0 c:\users\voodoomsr\valhala 1 c:\users\voodoomsr\valhala\witchcraft\expectopatronum 2 c:\users\voodoomsr\valhala\witchcraft\expectopatronum\comunidad 3 c:\users\voodoomsr\valhala\witchcraft\expectopatronum\comunidad\stack 4 c:\users\voodoomsr\valhala -> 5 c:\users\voodoomsr\valhala\witchcraft witchcraft>> hi all, found extrange thing don't understand. if execute set-location inexistence object list of directories. what that? i see it, can't reproduce it.   when enter you've got posted there, set-location error, because value of argument "path" null.     [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " " mistake!. after that, check alias cd , asigned function set-locationex. fu...
Read more

After enabling Windows Server 2012 R2 DHCP Failover Getting Packet dropped because of Client ID hash mismatch

-
we have 2 dhcp servers @ our site (they each located on different subnets).  these dhcp servers running windows server 2012 r2.  dedicated dhcp servers.  yesterday afternoon, reconfigured several scopes such become members of single dhcp failover relationship have configured load balance 50% of load placed on each dhcp failover relationship member (dhcp server). however, morning, users reported unable renew dhcp addresses.  looking dhcp logs on both dhcp servers, there several entries follow: "36,mm/dd/yyyy,hh:mm:ss,packet dropped because of client id hash mismatch or standby server.,ip subnet,,mac address,,0,6,,,,,,,,,0" i performed manual synchronization of failover relationship , scopes on both dhcp servers.  restarted dhcp service on both dhcp servers still getting same error. a bing/google search did not bring light issue encountering.  has encountered , if so, solution. i should add when attempted perform ipconfig/renew on workst...
Read more

WMI Repository 4GB limit - Win 2003 Ent Question

-
Image
hi there, i've question size limit on wmi repository (being 4gb). if isn't correct place post this, apologies , can let me know wheere post this? i've come across few servers running citrix have reached limit on wmi repository size , need install ibm director agent hw monitoring. during install getting 'out of disk space' errors entered in mofcomp.log: "(mon apr 02 04:10:36 2012.172843) : error occurred while processing item 4: (mon apr 02 04:10:36 2012.172843) : error number: 0x8004103b, facility: wmi description: out of disk space" when error number http://msdn.microsoft.com/en-us/library/windows/desktop/aa394559%28v=vs.85%29.aspx i see this: wbem_e_out_of_disk_space 2147749947 (0x8004103b) disk out of space or 4 gb limit on wmi repository (cim repository) size reached. windows xp , windows 2000/nt:   disk out of space. i'm wondering if there reason why limit set 4gb or can increase needs be? can't seem find reas...
Read more