Forum Discussion
Solved
TEXTSPLIT with multiple Occurances
Dear Experts, I have a data as attached and for each cell, I need to extract the Text between ", " and "Mhz". So for 1st cell : [] for bcs5: [{1, [6470945]}] and featureSetsW...
That could be
=ARRAYTOTEXT(TOROW(TEXTAFTER(TEXTBEFORE(TEXTSPLIT(A1,"{"), "Mhz" ),","),3))if you are on Excel 365
Hi,
=WEBSERVICE("https://e.anyoupin.cn/eh3/?preg_match_all_join~(?<=\s)\d+(?=Mhz)~" & A2)
Try this webservice.
=WEBSERVICE("https://e.anyoupin.cn/eh3/?preg_match_all_join~(?<=\s)\d+(?=Mhz)~" & A2)
Try this webservice.
=WEBSERVICE("https://e.anyoupin.cn/eh3/?preg_match_all_join~" & encodeurl("(?<=\s)\d+(?=Mhz)~" & A2))
https://support.microsoft.com/en-us/office/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4
If arguments are unable to return the data, WEBSERVICE returns a #VALUE! error.
Can you connect to below url with web browser e.g. Edge?
https://e.anyoupin.cn/eh3/?preg_match_all_join~(?%3C=\s)\d+(?=Mhz)~:%20[]%20for%20bcs5:%20[{1,%20[6470945]}]%20and%20featureSetsWithUlCellsTwoMimoLayers:CA_n25A-n41C-n66A-n77A%20and%20featureSetIndexes:[{6470947,%2010Mhz/10Mhz}]]%20is%20matched%20with%20[3]:[{6470945,%20100Mhz/100Mhz},%20{6470946,%2080Mhz/80Mhz}],%20n66[A][A]:[n41[C][A]