In our department i am in charge of putting together forms. We use a document
management system (DMS) that incorporates Word as our database's word
processer over the old dinosaur of a processor we used to have.
Anywhoo.... we use bookmarks in incorporate certain bits of info from our
database into documents (client's first names, last names, case numbers, etc.)
The following is what I use to delete leading zeros from a case number
bookmark:
the bookmark in this example is coded as CASNMI.
{=ABS ([CASNMI]) \# "###0" \*MERGEFORMAT}
The result of this coding within the document is a number like 44565 instead
of 00044565. It cuts off the leading zeros, resulting in a neater looking
document.
Okay, this leads me to the question that I have now. What coding do I use
to get the bookmark for the middle name to truncate it to just the first
middle initial.
So that instead of inserting the middle name as "Smith", my result would
just be "S".
No macros please, as they do not translate into the use of our DMS program.