How to get substrings from an Xpath using C#?

Question

I have an Xpath property inside of a JSON file and I'd like to get two substrings from this Xpath to assisting these substrings into two variables.

The JSON object is as follows;

    {
        'selectGateway':'0',
        'waitingTime':'20000',
        'status':'200',
        'correlationID':'1',
        'matchString':[{'xpath':'/whitelist/locations/location/var-fields/var-field[@key="whitelist-entry" and @value="8.0440147AA44A80"]','value':''}],
        'matchInteger':[],
        'matchSortedList':[]

    }

This is my attempt so far it's working properly, I'm just looking for a way to do this more dynamically and in a better way if it's possible.

int firstStringPositionForKey = matchString[index].xpath.IndexOf("@key=\"");
int secondStringPositionForKey = matchString[index].xpath.IndexOf("\" and");
string betweenStringForKey = matchString[index].xpath.Substring(firstStringPositionForKey+6, secondStringPositionForKey-firstStringPositionForKey-6);

int firstStringPositionForValue = matchString[index].xpath.IndexOf("@value=\"");
int secondStringPositionForValue = matchString[index].xpath.IndexOf("\"]");
string betweenStringForValue = matchString[index].xpath.Substring(firstStringPositionForValue+8, secondStringPositionForValue-firstStringPositionForValue-8);

I expect the output to be like:

key is : whitelist-entry
value is : 8.0440147AA44A80

What you tried so far? show us your attempts. Hint: you can use Split('/').Last() — Prasad Telkikar
– Prasad Telkikar, Commented Sep 27, 2019 at 11:49

Prasad Telkikar · Accepted Answer · 2019-09-27 13:14:28Z

1

I believe you are getting value of xPath in matchString[index].xpath, so here is the solution

//Test is nothing but your xPath
string test = "/whitelist/locations/location/var-fields/var-field[@key=\"whitelist-entry\" and @value=\"8.0440147AA44A80\"]";

//Split your string by '/' and get last element from it.
string lastElement = test.Split('/').LastOrDefault();

//Use regex to get text present in "<text>"
var matches = new Regex("\".*?\"").Matches(lastElement);

//Remove double quotes         
var key = matches[0].ToString().Trim('\"');
var @value = matches[1].ToString().Trim('\"');;

//Print key and value   
Console.WriteLine("Key is: ${key}");
Console.WriteLine("Value is: ${value}");

Output:

Key is: whitelist-entry
Value is: 8.0440147AA44A80

.net fiddle

edited Sep 27, 2019 at 13:14

answered Sep 27, 2019 at 12:46

Prasad Telkikar

16.1k7 gold badges26 silver badges49 bronze badges

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

2 Comments

zalky Over a year ago

Thanks a lot, this is exactly what I'm looking for.

Prasad Telkikar Over a year ago

I am glad that my answer helped. Kindly accept answer so it will help others to read

Innat3 · Accepted Answer · 2019-09-27 12:12:13Z

0

Using Regex (Link to formula)

var obj = JObject.Parse("your_json");
var xpath = ((JArray)obj["matchString"])[0]["xpath"].Value<string>();

string pattern = "(?<=key=\")(.*?)(?=\").*(?<=value=\")(.*?)(?=\")";
var match = new Regex(pattern).Match(xpath);

string key = match.Groups[1].Value;   
string value = match.Groups[2].Value;

answered Sep 27, 2019 at 12:12

Innat3

3,5762 gold badges15 silver badges30 bronze badges

Collectives™ on Stack Overflow

How to get substrings from an Xpath using C#?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related