For an APP10 customer, trying to set the logic to the report rule and raised the question.

 

In the report rules you can point to a variable in the XML  (example  Â@UNIFORM_PAYMENT_ADVICE_REP/IDENTITYS/IDENTITY/COMM_METHOD])    is it possible to add logic to this?  Example I want to remove the first 7 characters of that variable.  I tried  &select SUBSTR(t@UNIFORM_PAYMENT_ADVICE_REP/IDENTITYS/IDENTITY/COMM_METHOD], 7) from dual]    but that didn’t work.   I just wanted to make sure its possible to do what we want.

Reasoning

The Comm Method variable   is   ‘E-Mail:  jackdoug@gmail.com ‘    in order to actual use it, we need to strip off  ‘E-Mail:’

 

THanks