Forum Discussion
Missing formulas
I'm trying to extract data between characters and many sites reference TEXTBEFORE and TEXTAFTER. when I try to instigate said formulas, the result is #NAME? I searched through the formulas in Excel ...
The issue I have is that 2 pieces of data are between brackets
blah blah blah info [Data to extract] (useless info) [more useless info]
re:Is there even a way to do this?
=webservice("http://e.anyoupin.cn/eh3/?preg_match~\[(.+?)\]~blah blah blah info [Data to extract] (useless info) [more useless info]~1")
blah blah blah info [Data to extract] (useless info) [more useless info]
re:Is there even a way to do this?
=webservice("http://e.anyoupin.cn/eh3/?preg_match~\[(.+?)\]~blah blah blah info [Data to extract] (useless info) [more useless info]~1")
- That looks very phishy...
