Extract Each object from a CSV file using powershell

Question

I am new to Powershell.I have a csv file named samplemap.csv with values . I have to read each value from the file, like example a variable to define the value of paris_App.

CntryApp Version
paris_App 2.19
ila_App 5.3
sga_App 3.10

The code I used is printing all the CntryApp version , not printing each CntryApp version separately

Import-CSV "H:\samplemap.csv"
$CntryApp = @()
$Version = @()
 Import-CSV "H:\samplemap.csv" -Delimiter ';'
ForEach-Object {
        $CntryApp += $_.CntryApp
        $Version += $_.Version
}

Expected 2.19,5.3,3.10 to be assigned to a indivdual variable . I mean each CntryApp version to be assigned to a variable.

So you want $Mapping to have paris_App, ila_App and sga_App and $version to have all three versions? From the code I personally have no idea what you want to achieve... — Robert Dyjas
– Robert Dyjas, Commented Jun 14, 2019 at 19:10
Please add the info of what you want to achieve to the question. — Robert Dyjas
– Robert Dyjas, Commented Jun 14, 2019 at 19:20
I still don't follow, please add an example of what's the expected output (unless Matt guessed correctly what you mean). — Robert Dyjas
– Robert Dyjas, Commented Jun 14, 2019 at 19:26
Sorry for the confusion @robdy, my csv files contains cntry_App,version like key-value pairs , what i am trying to achieve is extract each cntry_app's version to a individual variable like to get value of paris_app $xyz=$cntryApp.version[0] — aditya pratti
– aditya pratti, Commented Jun 14, 2019 at 19:39

Matt · Accepted Answer · 2019-06-14 19:17:13Z

1

If I understand you correctly you want individual variables for each entry in your input file e.g. $paris_App? While that is possible using something like Set-Variable a better approach would be creating a hashtable of those key value pairs. That was you could call the version if you know the name.

$apps = @{}
Import-CSV "H:\samplemap.csv" -Delimiter ';' | ForEach-Object{
    $apps[$_.CntryApp] = $_.Version
}

$apps['sga_app']

This approach would fail if those CntryApp contained duplicates.

answered Jun 14, 2019 at 19:17

Matt

47k9 gold badges90 silver badges125 bronze badges

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

Comments

Robert Dyjas · Accepted Answer · 2019-06-14 19:44:50Z

To import data from .csv file (space-delimited in that case) you have to specify delimiter (unless it matches the default one which might be dependent on your regional settings and I'm pretty sure that space is not the default one).

If you want to use that data later, it's good to save the imported values to variable:

$t = Import-CSV "$($pwd.path)\samplemap.csv" -Delimiter ' '

Once you save it, you can access it using the following structure

# All values of CntryApp
$t.CntryApp

# Output
paris_App
ila_App
sga_App

# CntryApp and version of first object
$t[0]

# Output
CntryApp  Version
--------  -------
paris_App 2.19

# Version of first app
$t[0].Version

# Output 
2.19

As you mentioned key:value scenario, it'd be natural (although it might look a bit more complex) to consider hastable as @Matt suggested.

Collectives™ on Stack Overflow

Extract Each object from a CSV file using powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related