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),""),
Sadly this command does not seem to work it seem to pick up 2022 rather then the number next to X
E.G
User 2022 / x36 = This would pick up 2022 rather then 36
Remove User - <name of user> -BASE2000 = This would pick up 2000
E.G
User 2022 / x36 = This would pick up 2022 rather then 36
Remove User - <name of user> -BASE2000 = This would pick up 2000
=LET(
split, TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(A2,"x ","x")," ","-"),"-",,TRUE),
IFNA(NUMBERVALUE(SUBSTITUTE(INDEX(split,,XMATCH("*x*",split,2)),"x","")),"")
)- thanks this one also work well
1 issue is it cannot find the X number in the below. I am guess cos of the ( )
"B2K ID Deletion (x2 ID)" = came back with #VALUE! (should be 2)
each report is around 8k in rows. but even if this cannot be fixed with ( ) then anyhow this would save me a lot of time.
