Powershell split() function is returning more values than expected [duplicate]

Question

I have a csv file which conatins line something similar to this

"Some KIND of Test","[STATUS]","TESTNAME","VMNAME","TESTTME","SOME PARAMETER"

I am trying to parse this. I am using split to get STATUS and TESTNAME

$col = $line.split('","') #used .split('`",`"') as well
$col.length #output value is 18
#cl = $line.split(',')
$cl.length #output value is 6

Why am I seeing two different values here. In both cases ' and "," present same number of times

It seems like I am making some basic mistake. I couldn't figure it out. Any help would be grateful. Thanks

Mathias R. Jessen · Accepted Answer · 2017-09-14 14:18:54Z

2

The only resolvable overload for String.Split() treats the "," string argument as a character array and splits on each occurrence of any of the characters in the array.

Use the -split regex operator instead:

$col = $line -split '","'

If you really hate regex, you can force an overload of String.Split() that takes strings as separators by explicitly casting the first input argument to a string array:

$col = $line.Split([string[]]@('","'),[System.StringSplitOptions]::None)

edited Sep 14, 2017 at 14:18

answered Sep 14, 2017 at 10:32

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

3 Comments

srikanth peetha Over a year ago

Thanks. That is pretty straight forward.

user4003407 Over a year ago

If you're on version 2.0 where -split is not available Why did you say that?

Mathias R. Jessen Over a year ago

@PetSerAl Because my memory is bad, and it's poorly documented

Esperento57 · Accepted Answer · 2017-09-14 17:07:43Z

2

Why you dont use import-csv command like it?

import-csv "yourpathtofile"

if you want really use get-content you cando it too:

$string='"Some KIND of Test","[STATUS]","TESTNAME","VMNAME","TESTTME","SOME PARAMETER"'
$string | ConvertFrom-Csv -Delimiter "," -Header p1, status, testname, p4, p5 | select status, testname

answered Sep 14, 2017 at 17:07

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

Powershell split() function is returning more values than expected [duplicate]

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related