powershell script to extract specific column from csv file and store in array

Question

My csv file looks like this

Product_Name    Component           SvnDirectory
ABC             export-service      export
ABC             import-service      import
ABC             service-service     service

My script should read this file and extract SvnDirectory column and store its values(export, import,service)in an array. I will later be using this to checkout from svn.

The script is

$svnDirectory= Import-Csv C:\temp\checkoutdirs.csv | % {$_.SvnDirectory}
Write-host $svnDirectory

The problem with this is, it stores values in such a way that I am not able to use it to checkout from svn.

Output
@Write-host $svnDirectory
export    import    service

So when I try to checkout using this

ForEach ($i in $svnDirectory) {
    $checkoutUrl = "$svnRepositoryBase/$svnDirectory/trunk"
    Write-host "SVN url to be checked out is $checkoutUrl"
    java -classpath $env:CLASSPATH org.tmatesoft.svn.cli.SVN co $checkoutUrl --username $username --password $securePassword --non-interactive
}

The svn url it takes is

SVN url to be checked out is 
http://subversion.abc.com/dev/prj/export  import  service/trunk

I tried this and I get only the svnsubdirectory in the array $projectName = import-csv ABC_Projects.csv | % {$_.SvnDirectory} Write-host $projectName — VRK
– VRK, Commented Apr 21, 2015 at 22:14
Your loop is foreach ($i in $svnDirectory), but you're using $svnDirectory instead of $i to compose $checkoutUrl . — AdamL
– AdamL, Commented Apr 22, 2015 at 7:34

VRK · Accepted Answer · 2015-04-21 22:08:50Z

3

Alright i tried this and it worked

 $projectName = import-csv  ABC_Projects.csv | % {$_.SvnDirectory}
 Write-host $projectName

answered Apr 21, 2015 at 22:08

VRK

1,4063 gold badges14 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

powershell script to extract specific column from csv file and store in array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related