Powershell Import-CSV - Get Name and Value from the same line

Question

I'm trying to get from this file ->

File 1:

Name;Datum;Nominal;L_TOL;U_TOL;Value;Unit;Feature;low nat. Border;Type;No.;Date;Time;Operator

abstrich_;;   0.00;   0.00;   0.00;   0.02;mm;0;0;9315;1;16.03.23;14:59:02;xy
abstrich__;;   0.0;   0.0;   0.0;   0.2;mm;0;0;9315;2;16.03.23;14:59:02;xy
mp_658__;;   0.000;   0.000;   0.480;   0.164;µm;0;2;100;3;16.03.23;14:59:02;xy
rough01_Pt;;   0.000;   0.000;   0.810;   0.389;µm;0;2;9350;4;16.03.23;14:59:02;xy
rough02_Rz;;   0.000;   0.000;   0.500;   0.264;µm;0;2;9350;5;16.03.23;14:59:02;xy

to this format ->

File 2:

abstrich_;0.02
abstrich__;0.2
mp_658__;0.164
rough01_Pt;0.389
rough02_Rz;0.264

I don't know how to extract these two values and merge in one line.

I need a solution with Import-Csv which let me bring the first file in the second format.

Where are your attempts? You need to show what you've tried. — Destroy666
– Destroy666, Commented Mar 23, 2023 at 9:48
Use Export-CSV and specify only the columns you need : learn.microsoft.com/en-us/powershell/module/… — jdweng
– jdweng, Commented Mar 23, 2023 at 10:01
Import-Csv -Delimiter ";" -Path "source_path" | Select Name,Value | Export-Csv -Path "target_path" — Avshalom
– Avshalom, Commented Mar 23, 2023 at 10:02
Using this Join-Object script/Join-Object Module (see also: In Powershell, what's the best way to join two tables into one?): Import-Csv .\File1.Csv -Delimiter ';' |Update-Object (Import-Csv .\File2.Csv -Delimiter ';' -Header Name,Datum) -on name |Export-Csv .\Output.Csv — iRon
– iRon, Commented Mar 23, 2023 at 10:38

Destroy666 · Accepted Answer · 2023-03-23 10:09:40Z

2

This command does output the specified data to file if you want headers:

Import-Csv -Path "test.csv" -Delimiter ";" | Select Name,Value | Export-Csv -Path "test2.csv"

You import the CSV to an object list, then select only specified properties and save them to another CSV.

And this one can be used if you want no headers as in example:

(Import-Csv -Path "test.csv" -Delimiter ";" | Select Name,Value | ConvertTo-Csv -NoTypeInformation) | Select -Skip 1 | Set-Content -Path "test2.csv"

Here you again import the CSV and select only specified properties, then you need a workaround of converting to CSV format and skipping the 1st row of the full content. And you output the resulting content as CSV.

answered Mar 23, 2023 at 10:09

Destroy666

1,6002 gold badges19 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Powershell Import-CSV - Get Name and Value from the same line

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related