String Aggregation Function for matching text

[richard_chilvers]

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

[maxgro · Accepted solution]

my attempt in the attachment

[#3]

Try like below:

SubField( FieldDesc , ',',1) & ' ' & SubField( FieldDesc , ',',3)

[richard_chilvers]

Hi Massimo

Thanks for taking the time to understand my requirement and come up with a solution

Regards