Monday, September 29, 2014

Crystal Reports : Introduction to MID()

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.

3 comments:

Anonymous said...

At minimum, you will have start and cabin house designed for essentials and even a powerful winter snow storms pectoral, fake gucci considering becoming a mature along with a realistic project usually means that fortnight in family trip. chanel replica bags Some other attention once choosing everything that volume truck you should have is without a doubt the level of you desire to have the funds for propane gas, and even the correct way normally you have to refuel. replica hublot The general secret is without a doubt which will slighter trucks necessitate not as much propane gas so are alot more supply helpful, nevertheless trade-off is without a doubt not as much living room for one's stuff and even acquaintances. rolex replica A number of shops bear several trucks through many different supply conditions, as a result when you've car type in your head, dior replica achieve various groundwork with an enlightened talking along with a salesperson.

Coco Ada said...

Expensive and bound Rolex Réplique abroad from omega replica ability for that commoners. Therefore Replique Audemars piguet alarm Montres can action just as well. With the capabilities, accomplished and breeding around on par with that with the different Replique Audemars piguet alarm Montres will be awful admirable alms concepts for this blithe year or on any accident for that accomplish a difference. However to ensure you’re not bamboozled you accept to go hublot replica via accurate and reliable websites like http://www.Montresen.com that can action you you accomplished items at bargain amount with diffuse abiding customer assistance. They are able to aswell accommodate your get anon to cartier replica abetment you beat the time blitz and the majority of the items appear with assure and 1 agenda year guarantee. Due to the actuality Montresen.com action alone in the top in replique Montres, their amount of bounce is just about nil, but central the abominably break of animosity the applicant account agents will acceptable be decidedly added than agreeable to rolex replica become of assist.Audemars Piguet developed ultra-thin handbook ambagious motion application a array of one.65mm. This movement, the thinnest in the apple at time, absolutely fabricated a hit. As abundant as now, this almanac has not been torn by any motion that fabricated by acceptable Montre bearing technique. Now , acknowledgment appear the advance of quartz appearance technique, the array of movement could possibly be decidedly beneath than 1.0mm if abridgement of spring, adherence and escape caster and added basic parts.





tanki online said...


Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write.
Thanks for sharing !
tanki online 2 | 2048 game online