Skip to Content
0
Former Member
Dec 10, 2009 at 12:50 AM

Shorten string in line item in repetitive area

29 Views

I have a field with a number that is consistently XXX-XXX-XXX-XXX-R.C or XXX-XXX-XXX-XXX.c

I would like to print only the characters before the period, or in other words I would like to drop the .c on each printout. I had a substring calculation for 15 characters but the client now wants the flexibility to have 17.

Is this possible?