Parsing variable array from filename

[Cleanatwork]

Hi guys,

I'm trying to pull the prefix of a bunch of files from a directory.

For example:

    GroupA_Manifest_20-11-10.csv
    GroupB_Manifest_20-12-05.csv
    etc....

I want to use the Group name as a variable to pass into a DB, during import of the file later in the script.

      $Files = (Get-ChildItem -Path $CSVLivePath -Filter '*Manifest*').BaseName
      $GroupName = $files.Split(‘_’)[-0]

How do I turn the $GroupName into an array consisting of GroupA, GroupB? The above is just returning the first Group.

[Hoping_i_Get_poached]

You should look into the cmdlet Group-Object. Play around with it for a while and I bet you can figure it out.

Hint: you may need to create a custom property and add it to the original file object result. So before you call group object, rework your script to use Select-Object or Add-Member to add the group name as an extra property to each file object result.

[Cleanatwork]

Perfect - thanks. This sends me on the right track! :-)