This question has been asked before but I have been trying to work a solution in powershell but am not getting the desired results.
$line = '1,2,"N",09/04/13,"P09042013ZSD(1,0)","ZSD"'
[string[]] $splitColumns = $line.Split('(,)(?=(?:[^"]|"[^"]*")*$)', [StringSplitOptions]'RemoveEmptyEntries')
When I loop though the split values I am expecting
1
2
"N"
09/04/13
"P09042013ZSD(1,0)"
"ZSD"
But am getting
1
2
N
09/04/13
P09042013ZSD
1
0
ZSD
I have tested the regex using http://regexhero.net/tester/ (Split) with ExplicitCapture set and it returns the desired results.
Working solution
$RegexOptions = [System.Text.RegularExpressions.RegexOptions]
$csvSplit = '(,)(?=(?:[^"]|"[^"]*")*$)'
$splitColumns = [regex]::Split("StringHere", $csvSplit, $RegexOptions::ExplicitCapture)
split("(? =\"[^\"]. *\")");
To split a string with comma, use the split() method in Java. str. split("[,]", 0);
Question marks and exclamation marks go inside the quotation marks when they are part of the original quotation. For split quotations, it's also necessary to add a comma after the first part of the quotation and after the narrative element (just like you would with a declarative quotation).
[string].split()
method doesn't accept regex
on split but just [char[]]
or [string[]]
.
You can try like this:
$line -split ',(?=(?:[^"]|"[^"]*")*$)'
powershell -split
accept regex
for splitting text
Using .net you can do it like this:
[regex]::Split( $line , ',(?=(?:[^"]|"[^"]*")*$)' )
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With