Forum Discussion
Find number before and after "x"
I have been playing around this for a wile and cannot get it working. I currently use =MID(B2,FIND("x",B2,1),15) (but this is very basic and i have to do alot of editing as it also pulls over "X" (E...
- check line 5:
out,IFERROR(INDEX(FILTER(vals,NOT(ISERROR(--vals)),0),1),0),
and make it
out,IFERROR(INDEX(FILTER(vals,NOT(ISERROR(--vals)),""),1),""),
=webservice("http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~Users - Multiple x7 - BA2000 X7~1")
http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~Users x13- BA2000 13x~1
=webservice("http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~Users x13- BA2000 13x~1")
=webservice("http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~" & a2 &"~1")
http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~Users x13- BA2000 13x~1
=webservice("http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~Users x13- BA2000 13x~1")
=webservice("http://e.anyoupin.cn/eh3/?preg_match~(?:(?:[xX]\s*)(\d+))|(?:(\d+)(?:\s*[xX]))~" & a2 &"~1")
