Use multiple columns from a CSV in the one command.

Perfect. Thanks very much.

Actually, I seem to be having a problem with this.

the command runs ok but it doesn't give any output. I'm not sur eif it makes any different but the CSV is not piped into the full command. I've added the contents of the CSV to a variable as follows as a test:

$userlist = import-csv c:\Users.csv
   
$output123 = "$($userlist.givenname) $($userlist.surname)"

$output123

That's not a proper test. You need to pipe $userlist and use $_ (a current pipeline object):

import-csv .\test.csv | foreach { "$($_.firstcolumn) $($_.secondcolumn)" }

the script I have written doesn't have the CSV piped in though as there's a number of actions it performs on the same set of data.

Is it only possible to merge columns when piped in to the command then?

You can use foreach statement as well. It's hard to help you, if we don't know how your code looks like. I don't understand why can't you use a pipeline.

Hi Aleksandar,

Basic script shown here:

 $folderlist = import-csv c:\temp\forec.csv
foreach ($folder in $folderlist){
new-item -type directory -path c:\temp\hi -name $folder.FolderName;
}

Note: I used only one column named "FolderName" above

My question is I would like use multiple column for making folders e.g.: new-item -type directory -path c:\temp\hi -name $folder.FolderName01 $folder.FolderName02;

I am just interested how I can, but this script below did not work:

 $folderlist = import-csv c:\temp\forec.csv
foreach ($folder in $folderlist){
new-item -type directory -path c:\temp\hi -name $($folder.FolderName01)$($folder.FolderName02);
}

Note: I used two columns in csv : FolderName01, FolderName02

Would you please suggest?

R.

I don't understand what do you want to accomplish. Do you want to create a folder and a subfolder in one go? What is the connection between FolderName01 and FolderName02?

I am just qurious , how can i create folders in "C:\Temp\hi" from two column csv file with foreach-object. Nothing Special. It may seem to stupid idea, but like to examine more than one column csv file.. just learning of view.. Hopefully i've been understandable.. Sorry if not, but if you gave any idea?

Note: I know that, in normal way it would be more than enough only one column to create folders.

So take for example you have csv file that looks like this:

You saved it as TwoColumns.csv in your current directory so you import it to your powershell session using: 

$csvData = Import-Csv -Path '.\TwoColumns.csv'

and this is how the data look like:

$csvData | Format-Table -AutoSize

FirstHalf   SecondHalf
---------   ----------
Program     Data      
Application Data  

The data are imported as array of objects - each object represents one row. Each object has properties named according to column headers, let's see it: Type of the container:

$csvData.GetType().FullName

System.Object[]

Properties of one of the objects:

Get-Member -InputObject $csvData[0] -Name *Half

   TypeName: System.Management.Automation.PSCustomObject

Name       MemberType   Definition                     
----       ----------   ----------                     
FirstHalf  NoteProperty System.String FirstHalf=Program
SecondHalf NoteProperty System.String SecondHalf=Data 

By addressing the correct item and property you can get correct data. Folder name is a string so first build it. I am refering to the first row (the one after header row, shown as 2 in the excel)

$folderName = $csvData[0].firstHalf  + $csvData[0].secondHalf
$folderName 

ProgramData

Now let's combine it with foreach so instead of certain index in the csvData array we can use $row to refer to the current row directly and go through all rows in the imported collection: 

foreach ($row in $csvData)
{
    $folderName = $row.firstHalf  + $row.secondHalf
    $folderName 
}

ProgramData
ApplicationData

From here all you need to do is add the cmdlet that creates the folder and provide correct values for its parameters:

$csvData = Import-Csv -Path '.\TwoColumns.csv' -Delimiter ';' 

foreach ($row in $csvData)
{
    $folderName = $row.firstHalf  + $row.secondHalf
    new-item -ItemType Directory -Path c:\temp\hi -Name $folderName 
}

    Directory: C:\temp\hi


Mode                LastWriteTime     Length Name                                                           
----                -------------     ------ ----                                                           
d----       19. 4. 2013     12:09            ProgramData                                                    
d----       19. 4. 2013     12:09            ApplicationData 

Combining multiple attributes of an object, which is what you are attempting to do is done as shown by Aleksandar. Wrap the variable and its property in a $() construct, and place that in a string. 

Example, you are trying to combine two values of Get-Host:

This is similar to how it would work if you import a csv, for example:

Does that make sense?

Thank you for this, It's clear. :)

You are welcome .)

Hi nohandle,

Your explanation was enlightening, thank you.

I would like to know a little more. I have a two column csv file. The contents of the first column refers to a part of a folder name. The contents of the second column must be processed in the file names which are found in the folders by means of the first column. Do you think this is possible?