• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Multiple folders w/CSV files.. easy way to pull specific fields onto 1 Excel sheet?

Obsoleet

Obsoleet

Platinum Member
I have a powershell script that pulls data from SQL servers and puts each servers info into an individual file folder (CSV files).

Is there an easy way to pull certain fields from a few of the files in each directory and compile that data onto a single spreadsheet? This script runs by itself every month, and I'd like it to look for all the file folders that currently exist, and populate those values onto this 1 spreadsheet once it's opened.

Thank you
 
...And you can't create a View on the SQL server to do this, such that powershell pulls the view into a CSV file?
 
why dont you store the data in sql database and just odbc that into excel?

seems silly i'm sure you can create an odbc to a csv file but that seems like an extra step.

go into each dir and copy *.csv >> thismonthsjunk.csv ??
 
I ended up completely redoing my script to just output to a single file. It's not formatted perfectly right now, but I thought this was easier. Thank you though
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top