Advanced Report Creator - Calculated field SPLIT  [SOLVED]

Discuss your general Proclaim related queries here.
coastal_living
Posts: 17
Joined: Mon Sep 27, 2021 11:58 am
Has thanked: 8 times

Advanced Report Creator - Calculated field SPLIT

Post by coastal_living »

I'm trying to pick up the first character of the Case Key and I have tried using SPLIT but the report is outputting 0 for every row (none of the Case Keys start with 0) - what am I doing wrong?

SPLIT screenshot.jpg
SPLIT screenshot.jpg (90.65 KiB) Viewed 288 times

steve
Posts: 470
Joined: Wed Nov 30, 2011 10:20 pm
Been thanked: 120 times

Re: Advanced Report Creator - Calculated field SPLIT  [SOLVED]

Post by steve »

Hi,
in Adv Rpt Creator, the Calculated Field functions are not the usual Proclaim Maths script functions.
Change the Functions Dropdown to 'advanced' and use "SUBSTRING" for your purpose
SUBSTRING({Probate- case- key},1,1)
you'll probably want the return datatype to be "Character" too