Friday, March 27, 2015

GoldMine : Discovering the xBase Expression Tester

Ah, secrets! Is there nothing more mysterious? For instance, did you know that you can use CTRL-ESC to mimic a windows key? Try it. Right now. Isn't that awesome?

There is a correspondingly cool secret in GoldMine; the xBase Expression Tester. (I still can't bring myself to call it dBase - xBase just sounds so much more cool)

In GoldMine (requires MASTER rights), hit;


to invoke the Expression Tester.

The idea is to enter an expression in the top half and evaluate it against the Current Contact Record. So, the expression;


should return the Primary Conract of the Current Contact Record. Caps are mine, lowercase is fine.

So now we can start using all those neat dBase functions like MID, LEFT, TRIM. For instance,

LEFT(CONTACT1->CONTACT, 5) returns the first five characters of Contact.

AT(" ", CONTACT1->CONTACT) returns the numerical character position of the first occurrence of " " within Contact.

So, to get fancy, we could do this;

LEFT(CONTACT1->CONTACT,  AT(" ", CONTACT1->CONTACT)) to return only the First Name of the Contact.

Once you're happy with an Expression, they can be used in;

- Merge Documents
- Filters
- Global Replace
...just to name a few.

Even if you don't have a serious need for this, you can't deny it's pretty awesome. 

More dBase documentation than you could imagine can be found here;


Anonymous said...

Just what causes a powerful Omega as a result exact same -- That Co-Axial escapement. breitling replica George Daniels gotten these together through co-axial escapement model which will cuts back scrubbing and thereby means significantly greater excellence than only a sit back and watch which will functions with that lever escapement basic principle. breitling replica uk And also speed settings distinct a friend or relative notifies you they can demand attractive watch out for which will distinct product for one's special occasions, tag heuer replica uk though as soon as you read the rate with the enjoy oftentimes making plans for, rolex replica you no doubt know you will be not even maneuvering to grown to be allowed to have enough money for the application. fake hublot We Jaeger Lacoultre Grandma Outdoor activity produced using the same and that is built along with the the same prime quality prospects the fact that the unique Jaeger Lacoultre range manufactured through.

林磊 said...

2016-2-20 leilei
kate spade outlet
new balance shoes
adidas gazelle
louis vuitton purses
cheap ugg boots
michael kors handbags
canada gooses outlet
nike uk
michael kors outlet
louis vuitton outlet
louis vuitton handbags
coach factory
mcm handbags
cheap oakley sunglasses
mont blanc pens
michael kors bags
nike tn pas cher
fitflops shoes
ghd hair straighteners
longchamp pas cher
nike shoes
canada goose jackets
michael kors bag
hermes belt
timberland uk
adidas running shoes
ugg boots australia
christian louboutin outlet
air max 90
fitflops sale clearance
true religion sale
burberry outlet online
ed hardy uk
louis vuitton
michael kors uk
nike air max 95
coach outlet online
michael kors outlet
oakley outlet
fitflop sale