Powershell - parse CSV input with a specifiable delimiter

Question

How can I separate the data below into two columns delimited by semicolon?

GROUPING;SERIAL NUMBER              
-----------------------             
\\SDD\GMRN\CMM\KAYHA;18137521400329 
\\SDD\GMRN\CMM\KAYHA;18225521400335 
\\SDD\GMRN\CMM\KAYHA;18225521400341

My expected output is:

GROUPING               SERIAL NUMBER              
--------               --------------             
\\SDD\GMRN\CMM\KAYHA   18137521400329 
\\SDD\GMRN\CMM\KAYHA   18225521400335 
\\SDD\GMRN\CMM\KAYHA   18225521400341

Thanks!

What have you tried so far? stackoverflow.com/help/mcve

Rene Knop
– Rene Knop

2018-11-18 12:38:05 +00:00
Commented Nov 18, 2018 at 12:38 — Rene Knop
– Rene Knop, Commented Nov 18, 2018 at 12:38
im still searching.

Sheldon
– Sheldon

2018-11-18 12:40:56 +00:00
Commented Nov 18, 2018 at 12:40 — Sheldon
– Sheldon, Commented Nov 18, 2018 at 12:40

mklement0 · Accepted Answer · 2018-11-18 14:49:38Z

1

Sharing you the solution I've found:

When importing csv file, use (-Delmiter) :

 $csvfile = Import-Csv -Path $Dialog.FileName -Delimiter ";"

edited Nov 18, 2018 at 14:49

mklement0

452k68 gold badges728 silver badges988 bronze badges

answered Nov 18, 2018 at 12:54

Sheldon

115 bronze badges

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

Collectives™ on Stack Overflow

Powershell - parse CSV input with a specifiable delimiter

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