Powershell script to split up .csv file

The PowerShell script posted here by Jose Barreto can be used to split up a large .csv file that is difficult to open in Excel.

In this example we have a .csv file which has dates in the first column.

Enter the following script in PowerShell, listing the path of the source file [C:\FooFolder\2019.12.04\Book1.csv]; the date to split by [gt [datetime] "02/15/2010"]; and then the output file [C:\FooFolder\2019.12.04\Book1split2.csv]

$l=0; type C:\FooFolder\2019.12.04\Book1.csv | ? { ($l++ -eq 0) -or ([datetime] $_.Split(",")[0] -gt [datetime] "02/15/2010") } | Out-File C:\FooFolder\2019.12.04\Book1split2.csv -Encoding utf8

A new file will be generated that contains only the data from the first, with the entries after 2/15/2010 in the first column.

powershell to get a list of files in a folder

The PowerShell command will generate a list of all files in a folder. Enter it in this format:

Get-ChildItem -Path C:\FooFolder

Litigation Support Tip of the Night is taking a badly needed vacation far from home. Tips will be posted on the web site only during this period.

more on searching text files with powershell

The powershell script discussed in last night's Tip can be modified to search for multiple strings, and specify whether or not your search should be case sensitive:

Select-String -Path C:\FooFolder\txt\*.txt -pattern Art,Beauty,Law -CaseSensitive

Simply separate the strings to search for with commas, and then enter the condition, -CaseSensitive at the end.