javascript - google sheets substitute multiple -

i have google spreadsheet importing data website. when data pulled, has quotes , equal signs. can use substitute function rid of 1 of characters, when try use substitute function remove both quotes , text, sheets pulls 1 cell of data.

formula:

=importdata("https://ct.thecmp.org/app/v1/index.php?do=match&task=downloadmatchresultsdetail&matchid=12504&eventid=4&awardid=1") 

result:pulls data, includes quotes , = signs.

formula:

=substitute(importdata("https://ct.thecmp.org/app/v1/index.php?do=match&task=downloadmatchresultsdetail&matchid=12504&eventid=4&awardid=1"),char(61),"") 

result:pulls 1 cell of data, , gets rid of equal sign.

formula:

=substitute(substitute( importdata("https://ct.thecmp.org/app/v1/index.php?do=match&task=downloadmatchresultsdetail&matchid=12504&eventid=4&awardid=1"),char(61),""),char(34),"") 

**result:**pulls 1 cell of data , removes both quotes , equal signs.

a work around have been able achieve desired results: can use formula:

=importdata("https://ct.thecmp.org/app/v1/index.php?do=match&task=downloadmatchresultsdetail&matchid=12504&eventid=4&awardid=1") 

and use formulas like:

=substitute(substitute(b22,char(34),""),char(61),"") 

for every cell has imported data. it's not clean though, , if possible have done in 1 step.

one of complications run @ end of project importing data on phone's hotspot. location in has coverage, not reliable, way keep amount of data transferred @ minimum great.

link example spreadsheet: https://docs.google.com/spreadsheets/d/1-cv3llupzsrjrb4iztxvtdpstmp15xkwdmfkjpjopdi/edit?usp=sharing

you this: replace 'download 'parameter in download url word 'get' (see below):

instead of https://ct.thecmp.org/app/v1/index.php?do=match&task=downloadmatchresultsdetail&matchid=12504&eventid=4&awardid=1

put:

instead of https://ct.thecmp.org/app/v1/index.php?do=match&task=getmatchresultsdetail&matchid=12504&eventid=4&awardid=1

then use 1 function importhtml:

=importhtml("https://ct.thecmp.org/app/v1/index.php?do=match&task=getmatchresultsdetail&matchid=12504&eventid=4&awardid=1","table",1)