regexgoogle-sheetsgoogle-sheets-querygoogle-sheets-formula
IMPORTXML in Google Sheets and XPath
Site address: http://www.eng.kodex.com/product_view.do?fId=2ETF68
In Google Sheets, I want to crawl prices iNAV (KRW) in the site.
I found the XPath and typed the importxml function in the spreadsheet, but it does not work.
Could not parse imported XML content
XPath: //*[@id="container"]/section/div[2]/div[1]/ul/li[2]/div/p[1]
Solution
=REGEXEXTRACT(QUERY(TRANSPOSE(IMPORTDATA(
"http://www.eng.kodex.com/product_view.do?fId=2ETF68")),
"where Col1 contains 'basp:""'"), "(\d+.*)""")
or rounded:
=ROUND(REGEXEXTRACT(QUERY(TRANSPOSE(
IMPORTDATA("http://www.eng.kodex.com/product_view.do?fId=2ETF68")),
"where Col1 contains 'basp:""'"), "(\d+.*)"""))
- Issue with Regex Pattern (split string with characters & numbers)
- How to get the first Tamil letter in a word?
- The method of using Regular Expression to express Date and Time: YYYY-MM-DD HH:MM:SS.XXX
- validate the credit card expiry date using java?
- Using disjunction (OR) in a lookbehind
- See if a string contains any characters in it
- Multibyte trim in PHP?
- match only the last instance of a pattern with Javascript regexp
- Regex to detect negative numbers but not hyphenated numbers
- How to Fix regular expression capturing group error Bigquery?
- Improving the below RegEx for US and UK Names
- R quanteda kwic not matching negative look behind pattern
- Help with drivers license number validation regex
- Regex for matching grey colors in hexadecimal notation
- Extract email address from string
- Regex for ISO 8601 durations
- How to find second match in sql
- Regular expression to remove HTML tags
- How to replace host part of a URL using javascript regex
- How do I match all four cases in Regex?
- How to replace a period that is between letters, but not numbers?
- How to strip quotes from a variable in Ansible?
- Regular expression to accept negative number
- Negative Lookahead not working in perl regex
- How can I use perl to delete files matching a regex
- Is it possible to get a list of strings from a regex?
- extract the first word from a string - regex
- How to validate CNIC no in mvc by regular expression
- Named backreferences with preg_replace
- Regex for matching a certain number of words