
1. Re: Excel Search Function as
Tom W Sep 7, 2016 12:46 PM (in response to brandon.ercoline.0)2 of 2 people found this helpfulMy guess is you are using the MID/FIND functions wrong, perhaps ordering the parameters incorrectly.
My suggestion when faced with problems like this is break it down into smaller pieces. Like firstly try and solve how to get the position of BX_
Create a calculated field as;
find([Pages],"BX_")
Add that to your report as Discrete and you'll see it returns a number, that aligns to the expected value. Problem one solved!
Now build on that to use the mid function and keep stepping it out like that.
I.e. step two, use the MID function with no length specified;
MID([Urlval],FIND([Urlval],"BX_"))
Then figure out how to get the position of the first forward slash after the BX_
Chain it all together.... It looks like;
MID(
[Urlval],
//Start at the position of the BX_
FIND([Urlval],"BX_"),
//Length parameter
//Calculate the position of the first / after the BX_ minus the position of BX_
FIND([Urlval],"/",FIND([Urlval],"BX_"))FIND([Urlval],"BX_")
)

2. Re: Excel Search Function as
brandon.ercoline.0 Sep 8, 2016 8:00 AM (in response to Tom W)Thanks, Tom W! Worked flawlessly. Sincerely appreciate the educational aspect as well on stepping through from step 1 and building out from there.
Thnaks again,
BE 
3. Re: Excel Search Function as
Tom W Sep 8, 2016 8:03 AM (in response to brandon.ercoline.0)No problem! Please mark the answer as correct to close the thread.