Tuesday, October 26, 2010

Crystal Reports : Using MID() to cut out a substring

Let us suppose that we are reporting on history, and our field {HISTORY.REF} has some annoying characters padded into the beginning of the string, like this:
"oc: Justin Hill - Appointment"
"oc: Gene Marks - Phone Call"
"oc: Corey Babka - Next Action"

For cosmetic purposes, we will create a formula to strip out the "oc:" with the following code:

Mid({HISTORY.REF}, 5)

This will return the entire string, starting at character position five.

1 comment:

marko said...

Most moneylenders will never go recent hour after your application is affirmed. This implies you can even deal with crisis circumstances inside no time at all when you pick a payday advance. cash advance