Xpath question Xml Xpath
- by Ibrar Afzal
I need an xpath expression that would return the value of I need to get the value of this node. the value to extract is my xpath expression is
//rates/rate[loantype='30-Year Fixed Rate'] The issue hre is that there are three value each node has a subtype element. Beside fileter for loantype I also need to filter for subtype. I am not sure how to do it in xpath.
I have the following xml
40-Year Fixed Rate
A
3
5.375
1.000
5.491
0
1
40-Year Fixed Rate
B
5.500
0.500
5.579
0
1
40-Year Fixed Rate
C
5.625
0.000
5.667
0
1
30-Year Fixed Rate
A
3
5.000
1.000
5.134
0
1
30-Year Fixed Rate
B
5.125
0.500
5.215
0
1
30-Year Fixed Rate
C
5.250
0.000
5.297
0
1
20-Year Fixed Rate
A
3
4.875
1.000
5.055
0
1
20-Year Fixed Rate
B
5.000
0.500
5.121
0
1
20-Year Fixed Rate
C
5.125
0.000
5.187
0
1
15-Year Fixed Rate
A
3
4.250
1.000
4.467
0
1
15-Year Fixed Rate
B
4.375
0.500
4.512
0
1
15-Year Fixed Rate
C
4.500
0.000
4.570
0
1
10-Year Fixed Rate
A
3
4.125
1.000
4.435
0
1
10-Year Fixed Rate
B
4.250
0.500
4.454
0
1
10-Year Fixed Rate
C
4.375
0.000
4.473
0
1
High-Balance 15-Year Fixed Rate
D
3
4.250
1.000
4.461
0
1
High-Balance 15-Year Fixed Rate
B
4.375
0.500
4.512
0
1
High-Balance 15-Year Fixed Rate
C
4.500
0.000
4.563
0
1
High-Balance 30-Year Fixed Rate
D
3
5.000
1.000
5.130
0
1
High-Balance 30-Year Fixed Rate
B
5.125
0.500
5.211
0
1
High-Balance 30-Year Fixed Rate
C
5.250
0.000
5.293
0
1
30-Year Fixed Rate Jumbo
A
2
5.125
1.000
5.254
1
1
30-Year Fixed Rate Jumbo
B
5.250
0.500
5.336
1
1
30-Year Fixed Rate Jumbo
C
5.375
0.000
5.417
1
1
--
15-Year Fixed Rate Jumbo
A
2
5.000
1.000
5.220
1
1
15-Year Fixed Rate Jumbo
B
5.125
0.500
5.270
1
1
15-Year Fixed Rate Jumbo
C
5.250
0.000
5.320
1
1
--
3/1 30-Year Adjustable Rate
A
3
3.625
1.000
3.431
0
0
3/1 30-Year Adjustable Rate
B
3.875
0.500
3.448
0
0
3/1 30-Year Adjustable Rate
C
4.125
0.000
3.465
0
0
3/1 40-Year Adjustable Rate
A
3
3.875
1.000
3.438
0
0
3/1 40-Year Adjustable Rate
B
4.125
0.500
3.453
0
0
3/1 40-Year Adjustable Rate
C
4.375
0.000
3.467
0
0
5/1 30-Year Adjustable Rate
A
3
3.375
1.000
3.401
0
0
5/1 30-Year Adjustable Rate
B
3.625
0.500
3.457
0
0
5/1 30-Year Adjustable Rate
C
3.875
0.000
3.514
0
0
5/1 40-Year Adjustable Rate
A
3
3.625
1.000
3.441
0
0
5/1 40-Year Adjustable Rate
B
3.875
0.500
3.481
0
0
5/1 40-Year Adjustable Rate
C
4.125
0.000
3.531
0
0
7/1 30-Year Adjustable Rate
A
3
3.875
1.000
3.670
0
0
7/1 30-Year Adjustable Rate
B
4.125
0.500
3.755
0
0
7/1 30-Year Adjustable Rate
C
4.375
0.000
3.841
0
0
10/1 30-Year Adjustable Rate
A
3
4.375
1.000
4.092
0
0
10/1 30-Year Adjustable Rate
B
4.625
0.500
4.217
0
0
10/1 30-Year Adjustable Rate
C
4.875
0.000
4.342
0
0
--
2/2 ARM 30-Year (Purchase only)
DH
5.250
0.000
3.709
0
0
--
High-Balance 5/1 30-Year Adjustable Rate
D
3
3.375
1.000
3.366
0
0
High-Balance 5/1 30-Year Adjustable Rate
B
3.625
0.500
3.404
0
0
High-Balance 5/1 30-Year Adjustable Rate
C
3.875
0.000
3.454
0
0
High-Balance 7/1 30-Year Adjustable Rate
D
3
3.875
1.000
3.670
0
0
High-Balance 7/1 30-Year Adjustable Rate
B
4.125
0.500
3.755
0
0
High-Balance 7/1 30-Year Adjustable Rate
C
4.375
0.000
3.841
0
0
3/1 30-Year Jumbo Adjustable Rate
A
2
4.875
1.000
3.719
1
0
3/1 30-Year Jumbo Adjustable Rate
B
5.000
0.500
3.708
1
0
3/1 30-Year Jumbo Adjustable Rate
C
5.125
0.000
3.704
1
0
--
3/1 40-Year Jumbo Adjustable Rate
A
2
5.250
1.000
3.733
1
0
3/1 40-Year Jumbo Adjustable Rate
B
5.375
0.500
3.727
1
0
3/1 40-Year Jumbo Adjustable Rate
C
5.500
0.000
3.725
1
0
--
5/1 30-Year Jumbo Adjustable Rate
A
3
4.375
1.000
3.791
1
0
5/1 30-Year Jumbo Adjustable Rate
B
4.500
0.500
3.803
1
0
5/1 30-Year Jumbo Adjustable Rate
C
4.625
0.000
3.814
1
0
5/1 40-Year Jumbo Adjustable Rate
A
2
5.000
1.000
3.922
1
0
5/1 40-Year Jumbo Adjustable Rate
B
5.125
0.500
3.925
1
0
5/1 40-Year Jumbo Adjustable Rate
C
5.250
0.000
3.936
1
0
--
7/1 30-Year Jumbo Adjustable Rate
A
3
4.950
1.000
4.261
1
0
7/1 30-Year Jumbo Adjustable Rate
B
5.075
0.500
4.286
1
0
7/1 30-Year Jumbo Adjustable Rate
C
5.200
0.000
4.311
1
0
2/2 ARM 30-Year Jumbo (Purchase only)
DH
6.500
0.000
4.260
1
0
--
30 Due in 7 Fixed Rate JUMBO Balloon
A
6.375
1.000
6.613
1
0
30 Due in 7 Fixed Rate JUMBO Balloon
B
6.500
0.500
6.625
1
0
40 due in 7 Fixed Rate
offer1
5.250
0.000
5.374
0
0
1
40 Due in 7 Fixed Rate JUMBO Balloon
offer2
6.500
0.000
6.625
1
0
1
Interest Only HELOC
A
To 80% LTV
3.250
0
1
Home Equity Loan - 7Yrs
A
Up to $100,000.00
Up to 75% LTV
6.000
6.000
0
2
Home Equity Loan - 7Yrs
A
$100,000.01 - $250,000.00
Up to 75% LTV
6.00
6.153
0
2
Home Equity Loan - 7Yrs
A
Up to $100,000.00
Up to 80% LTV
6.250
6.250
0
2
Home Equity Loan - 7Yrs
A
$100,000.01 - $250,000.00
Up to 80% LTV
6.25
6.403
0
2
Home Equity Loan - 7Yrs
B
$100,000.01 - $250,000.00
Up to 90% LTV
6.99
7.145
0
2
Home Equity Loan - 10,15Yrs
C
$5,000-$250,000.00
To 75% LTV
6.50
6.612
0
2
Home Equity Loan - 10,15Yrs
C
$5,000-$250,000.00
To 80% LTV
6.75
6.863
0
2
Home Equity Loan - 10,15Yrs
D
$5,000-$250,000.00
Up to 90% LTV
7.50
7.614
0
2
Home Equity Loan - 20Yrs
E
$5,000-$250,000.00
To 75% LTV
7.50
7.566
0
2
Home Equity Loan - 20Yrs
E
$5,000-$250,000.00
To 80% LTV
7.75
7.817
0
2
Home Equity Loan - 20Yrs
F
$5,000-$250,000.00
Up to 90% LTV
8.50
8.569
0
2
Equity Edge
$5,000-$25,000.00
Up to 125% LTV
12.00
12.188
Current Index
0.350
Prime Index
3.250
03/26/2010