Topic: String * values Posted: 12 Aug 2014 at 8:55am
I have a string {field} that I would like to be able to group my report detail by.
examples of data in {field}.
DNR_DEF
DNR_MERGE
DNR_REC
CI_NO_DRAW
CI_DIFF_SETUP
I would like to be able to group all of the MANY fields that begin with "DNR" into one group and all of the fields that begin with "CI" into another group etc.
Is there a way that I can say let {field}DNR* ="DNR" and let {field}CI*=CR. And then group by the results of the new formula that I have created.
I don't know how or if I can use a "*" with my string variable?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 28 Aug 2014 at 4:29am
you may also consider something a little more dynamic if your data set is changing or you have a lot of options for the string field and you always want to group on the characters that precede the first instance of "_"
if instr({field},'_')>0 then split({field},'_')[1] else {field}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum