Remove first line in .csv file - PowerShellCommunity.org - Windows PowerShell Discussion Forums - Using PowerShell

Remove first line in .csv file

Last Post 11 Aug 2011 10:24 AM by mr_evans2u. 2 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

mr_evans2u User is Offline

New Member
Posts:32
Avatar

11 Aug 2011 08:16 AM
I am writing to a .csv file but when I pull it up the first row has: #TYPE selected.Quest.ActivRoles.ArsPowerShellSnapIn.Data.ArsUserobject I don't want this in there, how can I delete this row and still keep all my columns? Here is the code I'm using: Get-QADUser -organizationalUnit $OU -IncludedProperties extensionAttribute4 -InactiveFor 90 \|Select-Object DisplayName,email,extensionAttribute4 \|export-csv $OUusers

halr9000

PowerShell MVP, Site Admin

Advanced Member
Posts:565
Avatar

11 Aug 2011 08:55 AM
Use the -NoTypeInformation parameter with export-csv.

Community Director, PowerShellCommunity.org Co-host, PowerScripting Podcast Author, TechProsaic

mr_evans2u User is Offline

New Member
Posts:32
Avatar

You are not authorized to post a reply.

Active Forums 4.3