'Try to importxml wildcard character function

I am using importxml function to extract some info

=IMPORTXML("url","//span[@class='circle-with-text grade-D']")

I need to replace D with any other letter,trying to use "" or '' or '?' etc with no results. "AN?" idea?

Solution 1:^[1]

'=IMPORTXML("url","//span[@class='circle-with-text grade-D']")'.replace(/D/,"A"); It's the only capital D.

Solution 2:^[2]

Use SUBSTITUTE.

As per the Help Docs:

SUBSTITUTE

Replaces existing text with new text in a string.

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

text_to_search - The text within which to search and replace.

search_for - The string to search for within text_to_search.

search_for will match parts of words as well as whole words; therefore a search for "vent" will also replace text within "eventual".

replace_with - The string that will replace search_for.

occurrence_number - [ OPTIONAL ] - The instance of search_for within text_to_search to replace with replace_with. By default, all occurrences of search_for are replaced; however, if occurrence_number is specified, only the indicated instance of search_for is replaced.

So:

=IMPORTXML("url",SUBSTITUTE("//span[@class='circle-with-text grade-D']", "D", "A"))

replaces all Ds in the formula with As.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Cooper
Solution 2

'Try to importxml wildcard character function

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]