Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data looks like:
Code, Description, Value
ABC, 20% discount , £100
ABC, 20% discount voucher, £200
ABC, 20% discount with money back, £140
DEF, another discount, £20
etc.
I have a straight table chart to aggregate (SUM) values by Code:
ABC £340
DEF £20
etc.
Is there a string function to show the first n matching characters in Description?
Eg. ABC, 20% discount, £340
my attempt in the attachment
Try like below:
SubField( FieldDesc , ',',1) & ' ' & SubField( FieldDesc , ',',3)
Hi Massimo
Thanks for taking the time to understand my requirement and come up with a solution
Regards