header1   header
header
header : : Login header
header
connector   connector
menuleft
Home
Forums
Scripts
User Groups
Resources
About
 menuright
submenu   submenu
left
IMPORTANT: PowerShellCommunity.org is moving! - Wednesday, August 15, 2012

PowerShellCommunity.org is moving!  This community software, and the hardware that it sits on, are no longer serving the purposes of this community.  As a result, we have decided to move this community to a new home at PowerShell.org.  PowerShell.org is already up and running with the new community software and in its new location, so please post any new questions that you have on the forums over there instead of posting them on this site.  We've already started getting some great questions from members of the community over there so please, come on over and join us!

While we are going through this transition, this site will remain up for the short term.  New posts may no longer be created on these forums, however replies to existing posts are allowed so that users who posted questions don't have to re-post the same question on the new site.

[UPDATE 28/02/2013] New user registration has been disabled and forums have now been switched to read-only, including for existing posts since all threads that were started should now be completed. If you have a question about content on this site or about PowerShell in general, head over to PowerShell.org and ask it there where there are people actively using the site and answering questions.

If you have any questions, please let us know on the PowerShell.org site.

Thank you,

Kirk "Poshoholic" Munro

 
Forums > Looking Ahead > Using PowerShell v2.0
Exporting to multple CSV
Last Post 12 Mar 2010 12:19 AM by RvdNieuwendijk. 1 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
DBUser is Offline
New Member
New Member
Posts:2
Avatar

--
06 Mar 2010 05:49 AM
    Does anyone in the planet know how to export to multiple CSV. I searched the web bought a few powershell books and it looks like this can't be done.

    Here is my script:

    Import-csv c:\Report.csv | where {$_.department -match "Network"} | export-csv C:\Data.csv
    Import-csv c:\Report.csv | where {$_.department -match "Development"} | export-csv C:\Dev.csv
    Import-csv c:\Report.csv | where {$_.department -match "Testing"} | export-csv C:\test.csv
    Import-csv c:\Report.csv | where {$_.department -match "Marketing"} | export-csv C:\Marketing.csv

    As you can see this works fine but I have a 100 department which means i will have a hundred line of code, any help would be appreciated.

    Gracia,
    Thanks
    RvdNieuwendijkUser is Offline
    New Member
    New Member
    Posts:3
    Avatar

    --
    12 Mar 2010 12:19 AM
    What about:

    "Network","Development","Testing","Marketing" | ForEach-Object {
    $Department = $_
    Import-csv c:\Report.csv | where {$_.department -match $Department} | export-csv "C:\$Department.csv"
    }

    Robert
    You are not authorized to post a reply.

    Forums > Looking Ahead > Using PowerShell v2.0
    Active Forums 4.3
    		right
    footer   footer
    footer Many thanks to our original sponsors: Quest Software • SAPIEN Technologies • Compellent • Microsoft footer
    footer   footer