Numeric switch to truncate and replace on right side of number

**snoproladd** · 10-01-2012, 11:04 AM

I'm generating some labels to track some parts in my facility. The layout is simple. All refrer to a master drawing, for example 12345100. The individual parts are labeled 12345101, 12345102 and so on. What is the numeric switch to cut off the last two digits and replace with an 01, 02, 03 and so on?

**macropod** · 10-02-2012, 06:05 AM

Assuming you're working with fields, you'd need to embed the exisiting field in a formula field, coded as:
{=MOD('label field',100)}

**snoproladd** · 10-08-2012, 08:51 AM

Hey thanks a lot. It had some function but I'm definitely having some problem with the syntax. Are there any pointers you could give me? I'm very new to fields...more of an excel and that's a stretch still.

Thanks.

**macropod** · 10-08-2012, 05:09 PM

Perhaps I've missed something. Are you trying to extract just the last two digits, or replace them with something else? Also, is this a label mailmerge?

**snoproladd** · 10-09-2012, 08:20 AM

I'm actually trying to keep only the first six digits and modify the last 2. Yes, this is a label mail merge to answer your question. The main number (49401100) is a main drawing and the numerical label for the enire set, while the subsequent numbers (49401101-49401105) are individual drawings related to the first.

**macropod** · 10-09-2012, 09:36 AM

OK, given that it's a mailmerge, your mergefield probably looks something like:
«DrawingID»

To eliminate the last two digits:
• select the «DrawingID» mergefield in the first label and press Ctrl-F9 to create a pair of field braces. You should see: { «DrawingID» }
• edit the field contents so that you end up with {=INT(«DrawingID»/100)} (note that this is different to what I suggested previously).
• select the entire field and press Ctrl-F9 again, so that you end up with {{=INT(«DrawingID»/100)} }
• edit the field contents so that you end up with {QUOTE"{=INT(«DrawingID»/100)} }
• between the last pair of field braces press Ctrl-F9 twice more, so that you end up with {QUOTE"{=INT(«DrawingID»/100)}{ { } } }
• edit the field contents so that you end up with {QUOTE"{=INT(«DrawingID»/100)}{=MOD({MERGESEQ},100) \# 00}"}
• press F9 to update the field display.
• update the remaining labels
• run the mailmerge

Note: The field brace pairs (ie '{ }') can't be typed or copied & pasted from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. If you mess up and need to edit the field code, press Alt-F9 to toggle the field display. This will change the «DrawingID» to {MERGEFIELD DrawingID}, but that's of no consequence.