RegEx to Parse SharePoint Multi-Value XML Result -
good day, fellow so'ers,
i'm using my favorite regex tool parse string:
5;#.net;#26;#asp.net;#1;#sharepoint;#3;#windows server;#20;#db2
i'm using powershell query sharepoint web services via caml i'm parsing returned xml meaningful psobject run business logic.
i going .split()
on ;#
did not result. note: may reconsider later answer more proper regex this...
the string result consistent, in format every time, starting number , ending no semi-colon ;
.
i want extract id , value. if it's not obvious, id being integer , value being string between #
, ;
.
my regex reflexes aren't quite batman-level yet, , particular string challenge me. want produce clean result consisting of id , value capture groups...
i think expression should work: /(\d+)(?:[;][#])([\w.]+)/g
Comments
Post a Comment