How to apply substring-after and substring-before functions

Question

My html structure as below

<td class="opps">1:2</td>

I am trying split value of td with XPath as below

.//*[contains(@class, 'opps')]/text()[normalize-space(substring-after(., ':'))]
.//*[contains(@class, 'opps')]/text()[normalize-space(substring-before(., ':'))]

But value returns 1:2

How can i extract 1 and 2 separately?

I am also using HtmlNodeNavigator and HtmlAgilityPack.

What is the wrong?

Thank you in advance.

Silly question, but if you can get the 1:2 value, why not split it in C# after parsing it out? — Oded
– Oded, Commented Mar 29, 2013 at 13:11
look at this answer on SO someone asked a similar question with a provided solution stackoverflow.com/questions/3964642/… — MethodMan
– MethodMan, Commented Mar 29, 2013 at 13:16
Not really answering my question. "Because I want to". Do you have any specific technical issue that means you must do it in XPath? — Oded
– Oded, Commented Mar 29, 2013 at 13:24
it applies using XPATH unless I am reading what he is wanting incorrectly.. — MethodMan
– MethodMan, Commented Mar 29, 2013 at 13:24

Kerberos · Accepted Answer · 2013-03-31 08:30:12Z

2

i found a solution after more search.

if use HtmlNodeNavigator or XPathNavigator, solution is possible as below

string _result1 = <HtmlNodeNavigator>.Evaluate("substring-after(.//*[contains(@class, 'opps')]/text(), ':')") as string; 
string _result2 = <XPathNavigator>.Evaluate("substring-before(.//*[contains(@class, 'opps')]/text(), ':')") as string;

answered Mar 31, 2013 at 8:30

Kerberos

1,2666 gold badges25 silver badges50 bronze badges

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

2 Comments

Tomalak Over a year ago

Kudos for finding your own answer. I've deleted mine.

Tomalak Over a year ago

Well, I've been dead wrong in saying that it was impossible (because I was only thinking in terms of the Agility Pack and HtmlAgilityPack.HtmlDocument), so it's only fair.

Mehmet Taha Meral · Accepted Answer · 2016-10-02 18:20:23Z

0

Just in case, you can use c# method for this too. For example;

string strVal = "1:2";
string[] splitedStrArr = strVal.Split(':'); 
// you have now 2 elements inside the array. You can use it separately

answered Oct 2, 2016 at 18:20

Mehmet Taha Meral

3,92133 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to apply substring-after and substring-before functions

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related