Question:
This is my code:
|
1 2 |
[regex]::split("1,2 3", '(,|\s)+') |
What I want is an array with three elements 1, 2, 3, however, what I got it is an array with five elements.
|
1 2 3 4 |
PS C:\Users\a> [regex]::split("1,2 3", '(,|\s)+').Length 5 PS C:\Users\a> |
How to get what I want?
Update
Add the actual split result instead of the length.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
PS E:\> [regex]::split("1,2 3", '(,|\s)+') 1 , 2 3 PS E:\> [regex]::split("1,2 3", '(,|\s)+').length 5 PS E:\> [regex]::split("1,2 3", '[,\s]+') 1 2 3 PS E:\> [regex]::split("1,2 3", '[,\s]+').length 3 PS E:\> |
Update
Thanks @Matt’s answer and it points me to the right direction. From help about_split the doc states that:
By default, the delimiter is omitted from the results. To preserve all
or part of the delimiter, enclose in parentheses the part that you
want to preserve.
Below are some of my testing.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 |
PS E:\tutorial> "Lastname/:/FirstName/:/Address" -split "/(:)/" Lastname : FirstName : Address PS E:\tutorial> "Lastname/:/FirstName/:/Address" -split "/:/" Lastname FirstName Address PS E:\tutorial> "Lastname/:/FirstName/:/Address" -split "(/:/)" Lastname /:/ FirstName /:/ Address PS E:\tutorial> "Lastname/:/FirstName/:/Address" -split "/:(/)" Lastname / FirstName / Address PS E:\tutorial> "Lastname/:/FirstName/:/Address" -split "(/):(/)" Lastname / / FirstName / / Address PS E:\tutorial> "Lastname/:/FirstName/:/Address" -split "(/)(:)(/)" Lastname / : / FirstName / : / Address PS E:\tutorial> [regex]::split("Lastname/:/FirstName/:/Address", '/(:)/') Lastname : FirstName : Address PS E:\tutorial> [regex]::split("Lastname/:/FirstName/:/Address", '/:/') Lastname FirstName Address PS E:\tutorial> [regex]::split("Lastname/:/FirstName/:/Address", '/:(/)') Lastname / FirstName / Address PS E:\tutorial> [regex]::split("Lastname/:/FirstName/:/Address", '(/):(/)') Lastname / / FirstName / / Address PS E:\tutorial> [regex]::split("Lastname/:/FirstName/:/Address", '(/)(:)(/)') Lastname / : / FirstName / : / Address PS E:\tutorial> |
Answer:
In PowerShell when you use a -split function if you have part of the match in brackets () you are asking for that match to be returned as well. I am sure that the same is true with the static method of [regex] as well. Consider the output from the two following commands (which are similar to yours) and you will see
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[regex]::split("1,2 3", '(,|\s+)') 1 , 2 3 [regex]::split("1,2 3", ',|\s+') 1 2 3 |
In the first example you see that the comma and whitespace have been returned as elements. What I am explaining is documented in About_Split
By default, the delimiter is omitted from the results. To preserve all
or
part of the delimiter, enclose in parentheses the part that you want to
preserve.
In this particular case
As pointed out in the comments there are 2 more ideal regex strings that would handle this particular case better
(?:,|\s)+ or [,\s]+
Former using a non capturing group and latter being a character class.