Skip to Content
0
Former Member
Dec 12, 2008 at 05:22 PM

No Substring function?

338 Views

I'm trying to parse a Parameter in a Formula to have it displayed and this doesn't seem to work:

Right({?@ByPaymentType}, Length({?@ByPaymentType})-InStr({?@ByPaymentType}, "By")+1)

Tried this too:

Right({?@ByPaymentType}, Length({?@ByPaymentType})-InStr({?@ByPaymentType}, "By")+3)

It is displaying the entire value of the Parameter, @ByPaymentType.

The values being passed are one of the following:

"By Cash"
"By Check"
"By Credit Card"
"By Money Order"
"By Direct Deposit"
"By Wire Transfer"
"By Other"

and I want to display:

"Cash"
"Check"
"Credit Card"
"Money Order"
"Direct Deposit"
"Wire Transfer"
"Other"