Thursday, May 29, 2014

Crystal Reports : MID() Refresher

Ah, MID(). Is there anything you can't do?

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.Using the function as outlined above will return;

"Justin Hill - Appointment"
"Gene Marks - Phone Call"
"Corey Babka - Next Action"

This is also great for cutting out parts of model numbers, serial numbers, etc.


1 comment:

maymay said...

They're able to give the useful issues with becoming a way more sophisticated variety of receiver for your personal pet dog plus developing these folks get noticed while you find them outside around online community : by using properties these kind of when diamante studs and also pretend diamond rings this rolex replica uk your essentially exquisite might seem. There's a simple gigantic offer popularity to get traditional engagement jewellery and also timeless happy engagement rings. Ladies want exceptional plus 1-off types so that you can compliment its wedding and reception fake watches. Luckily they are sampling profound within grandma's rings common box to locate outside a retro hold dear to implement when its "anything old" and also "something borrowed". Conversely there are actually a good amount of excellent serious traditional elements on sale during goal engagement knick nacks cover anything from impressive geometric paintings deco layouts so that you can extravagant 50's diamante types. You may not whip 1950s diamante. Modern diamante chanel replica just simply never study together with the level of quality, design and style plus design place in timeless diamante jewellery, brooches and etc with the past. You may frequently measure the excellent on the traditional rings supplement by way of it is really excess fat. Reliable traditional merchandise is often overpriced nonetheless once they will be sounded perfect replica watches uk, they should never need eliminate its reward greater than time frame that will often be passed down know-how just after times. Timeless ceremony rings kinds deliver the results highest quality by using old lace and also primary chiffon dresses. A lovely fancy diamante brooch might might seem amazing use your bow middle sash or even harmless your imitation rolex replica for your personal cold months big event motif.