Google App Script Regex

Question

I am using the following code in Google app script to extract a number.

function getBTC_ZAR_ExchangeRate() {
  var response = UrlFetchApp.fetch("http://coinmill.com/rss/BTC_ZAR.xml")
  var xmlText = response.getContentText();
  //var funded = Xml.parse(htmlText, true);
  var rate = xmlText.match(/BTC =\s(.*?)\sZAR<br/);    
  return rate[1];
}

I get an array with two items as a result. Only the second item in the array is the correct one.

result = {"BTC = 27.45 ZAR<br", "27.45"}

What am I doing wrong, because this cannot be the way it is suppose to work?

Phil Bozak · Accepted Answer · 2013-02-27 13:32:04Z

2

This is the expected behavior. See the first example on MDN. The values returned from match are 1. the pattern that you matched (you told it to match that whole thing, so it did; 2. followed by the value(s) from that pattern matched (in your case 27.45).

answered Feb 27, 2013 at 13:32

Phil Bozak

2,8401 gold badge21 silver badges27 bronze badges

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

2 Comments

Rynardt Over a year ago

So is there a correct way of only getting the one correct answer I want?

Phil Bozak Over a year ago

You can read about a similar quesetion here. All solutions I have seen involve getting the second element. You can safely assume that [1] will not return an error if there is a match.

sjsyrek · Accepted Answer · 2015-06-13 04:46:40Z

0

As Phil Bozak answered, this is how match works. But this is a JavaScript function and has nothing to do otherwise with Google Apps Script specifically.

answered Jun 13, 2015 at 4:46

sjsyrek

1931 silver badge8 bronze badges

Collectives™ on Stack Overflow

Google App Script Regex

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related