I love using JSON, as Powershell can really good handle it from scratch and you need it a lot if handling Rest-APIs.
So basically when I stumbled across an issue to seperate s specific string into values, I wondered if JSON could help me.
The string basically is looking like: „CLIENTNAME=aaaaaa&CLIENTADDRESS=10.10.10.10“ (the more versatile users under you might recognize the CS-URI-QUERY of Citrix Workspace App).<\/p>\n\n\n\n
So whats the challenge?<\/strong> This is my solution with using JSON:<\/strong><\/p>\n\n\n\n What is the output of this?<\/strong><\/p>\n\n\n\n Here we have a very nice PS-Object.<\/p>\n\n\n\n Now, what did I do? <\/strong> kind of weird way, but this code has for my usage a lot of advantages:<\/strong><\/p>\n\n\n\n 1. The value-pairs can be in any order, so „CLIENTNAME=aaaaaa&CLIENTADDRESS=10.10.10.10“ or „CLIENTADDRESS=10.10.10.10&CLIENTNAME=aaaaaa“ 2. Any additional values that are in the string will be dropped, eg: Whats very import: the data has to have the same look, as additional „“ around a value will make this scriptblock break!<\/p>\n\n\n\n Update:<\/strong><\/p>\n\n\n\n Mathias R. Jessen<\/a> posted me an even better way on Twitter:<\/p>\n\n\n\n This is now really a very short code for doing this job. Thanks Mathias, this is how the powershell community works together!<\/p>\n","protected":false},"excerpt":{"rendered":" I love using JSON, as Powershell can really good handle it from scratch and you need it a lot if handling Rest-APIs.So basically when I stumbled across an issue to seperate s specific string into values, I wondered if JSON … Weiterlesen
I want to parse this string and even if there is more information inside like „Blahblah=uusudfu“, I only want Clientname and Address information.<\/p>\n\n\n\n$inputvalue=\"CLIENTNAME=aaaaaa&CLIENTADDRESS=10.10.10.10\"\n\n$Result=\"{`\"$($inputvalue -replace '=','\":\"' -replace '&','\",\"')`\"}\" | ConvertFrom-Json\n$Result<\/code><\/pre>\n\n\n\nIP ClientName\n-- ----------\n10.10.10.10 aaaaaa<\/code><\/pre>\n\n\n\n
I added to the string the brackets around it to make it a JSON and then replaced all delimiters by the approriate values. The Output looks like this after the replaces and the adding ot {} and before the ConvertFrom-Json:<\/p>\n\n\n\n{\"CLIENTNAME\":\"aaaaaa\",\"CLIENTADDRESS\":\"10.10.10.10\"}<\/code><\/pre>\n\n\n\n
delivers the same output<\/p>\n\n\n\n
„CLIENTNAME=aaaaaa&CLIENTADDRESS=10.10.10.10&USERNAME=jsdfhdjkfhjs&TEST=hgjhggj“<\/p>\n\n\n\n$inputvalue=\"CLIENTNAME=aaaaaa&CLIENTADDRESS=10.10.10.10\"\n\n$Result=$inputvalue -replace '&',\"`n\" | ConvertFrom-StringData\n$Result<\/code><\/pre>\n\n\n\n