Capture value in a variable using regEx and findText

Question

I'm trying to capture the number 10.0006 from the line:

total time: 10.0006s

which is one line in a text file. So far I have:

var doc = DocumentApp.openByUrl('removed url').getBody().editAsText();

//locate totalTime text
var regEx = "/(?<=total time: )([\d\.]+[\d])(?=s)/";
var totalTime = doc.findText(regEx).getElement().getText();

//display values in log
Logger.log(totalTime);

According to https://developers.google.com/apps-script/reference/document/text#findText(String) capture groups are not supported with findText, are there any other ways to capture the pattern? Thanks in advance!

Please add a brief description of your search/research efforts about regular expressions. Reference How to Ask. — Wicket
– Wicket, Commented Jan 20, 2018 at 0:09

user555121 · Accepted Answer · 2018-01-20 11:52:38Z

0

You can try do it with two steps

find needed element with findText.
use JavaScript's match with same regex to match needed group of characters.

var doc = DocumentApp.openByUrl('removed url').getBody().editAsText();

// locate totalTime text
var regEx = "total time: ([0-9.]+)s";
var foundRange = doc.findText(regEx);

// if range is found
if (foundRange)
{
  // get related element ant it's text
  var foundText = foundRange.getElement().getText();
  // capture needed group of characters
  var totalTime = foundText.match(regEx)[1];

  //display values in log
  Logger.log(totalTime);
}

answered Jan 20, 2018 at 11:52

user555121

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

1 Comment

Marisa Over a year ago

Thanks @Kos, I ended up using our suggestion with a few tweaks shown below:

Marisa · Accepted Answer · 2018-01-22 19:55:41Z

0

Here's what I ended up going with, thanks @Kos for the help!

// locate totalTime text
    var findLine = "total time:";
    var foundRange = doc.findText(findLine);


// if range is found
if (foundRange)
{
  var regEx = /[\d\.]+[\d](?=s)/
  // get related element and it's text
  var foundText = foundRange.getElement().getText();
    Logger.log(foundText);
  // capture needed group of characters
  var totalTime = foundText.match(regEx);

  //display values in log
  Logger.log(totalTime);
}

answered Jan 22, 2018 at 19:55

Marisa

34 bronze badges

Collectives™ on Stack Overflow

Capture value in a variable using regEx and findText

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related