Hello,
Can anyone help to create a formula to extract 2 characters from the left of "pp" in a field using CR XI?

Field = {MainEstimateDetails.JobDescription} (string)

Sample string details:

"Annual Report 96pp & Cover 12345"  - want to be able to show only 96 (from 96pp)
"CTP A4 4pp" - want to be able to show only 4 (from 4pp)

The string length is variable and the "pp" will be in different places each time.

It is probably very simple, but I cannot get it :(

Hi,
I get an error of "Start position is less than 1 or not an integer".

Perfect!

I used
local numbervar iStart := instr({MainEstimateDetails.JobDescription}, "pp");
if iStart > 0 then
 mid( {MainEstimateDetails.JobDescription}, instr( {MainEstimateDetails.JobDescription}, "pp") - 2, 2)
else
  "no pp"