2 of 2 people found this helpful
My 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;
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;
Then figure out how to get the position of the first forward slash after the BX_
Chain it all together.... It looks like;
//Start at the position of the BX_
//Calculate the position of the first / after the BX_ minus the position of BX_
No problem! Please mark the answer as correct to close the thread.