<div>
great - just had to add |export-csv d:\ap\temp\out.csv to wrtie it to a file.<br />
Thanks!
</div>


great - just had to add |export-csv d:\ap\temp\out.csv to wrtie it to a file.
Thanks!

<div>
<div class="content wysiwyg-content">
I am looking to do a directory listing of files and split up the path and file names into fields and create a csv file to import into a document mangement system - so from this dir list:<br />
d:\ap\pcard\fax\mary_1234.<wbr />tif<br />
d:\ap\pcard\fax\joe_1342.t<wbr />if<br />
d:\ap\pcard\email\john_246<wbr />8.pdf<br />
d:\ap\pcard\scan\jill_2222<wbr />.pdf<br />
I would want this file:<br />
date, source, name, acct#, file path<br />
2/17/2011,fax,mary,1234,d:<wbr />\ap\pcard\<wbr />fax\mary_1<wbr />234.tif<br />
2/17/2011,fax,joe,1342,d:\<wbr />ap\pcard\f<wbr />ax\joe_134<wbr />2.tif<br />
2/17/2011,email,john,2468,<wbr />d:\ap\pcar<wbr />d\email\jo<wbr />hn_2468.pd<wbr />f<br />
etc<br />
--<br />
I have parts of this figured out but can't seem to put it all together.
</div>
</div>


I am looking to do a directory listing of files and split up the path and file names into fields and create a csv file to import into a document mangement system - so from this dir list:
d:\ap\pcard\fax\mary_1234.tif
d:\ap\pcard\fax\joe_1342.tif
d:\ap\pcard\email\john_2468.pdf
d:\ap\pcard\scan\jill_2222.pdf
I would want this file:
date, source, name, acct#, file path
2/17/2011,fax,mary,1234,d:\ap\pcard\fax\mary_1234.tif
2/17/2011,fax,joe,1342,d:\ap\pcard\fax\joe_1342.tif
2/17/2011,email,john,2468,d:\ap\pcard\email\john_2468.pdf
etc
--
I have parts of this figured out but can't seem to put it all together.

split file path and names into &quot;fields&quot; and create csv file with list

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

split file path and names into &quot;fields&quot; and create csv file with list

split file path and names into "fields" and create csv file with list