Skip to Content
0
Former Member
Apr 22, 2008 at 11:32 PM

Removing extra text after a certain point for a field

13 Views

Post Author: ralph.devlin

CA Forum: Formula

Hello,

What we want to do is remove extra text, IE (PO12345.195) We would want to remove the .195 from the end of that data so that the groupings will group them correctly. How can I accomplish this. The defaul trim commands seem to only elimnate white space, I want to elimnate text up to a certain point. thanks

Ralph