Group by Field Content

rporter45
rporter45 used Ask the Experts™
on
Hi there,

Is there a way to trim data based on field content?

For example;

Other Campaign FYE 2019
Other Campaign FYE 2020

I need to group by Other Campaign but need to remove all information from the FYE and after so that is says only Other Campaign.

I can't wrap my head around it - any help would be appreciated,

Thanks - CS
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
if len({GfCmps_1Cm.GfCmps_1Cm_Description})<9 then {GfCmps_1Cm.GfCmps_1Cm_Description}
else
left({GfCmps_1Cm.GfCmps_1Cm_Description},len({GfCmps_1Cm.GfCmps_1Cm_Description})-9)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial