Count in a Concatenation Field

Question

Hi Community.

Trying to figure out how to set up my concatenation.

I am creating a new filed which is a concatenation of other fields, so pretty much a High Level Summary.

I also want to count how many times a value comes up in a field and have it part of the concatenation. Something like the below:

A + B + C + count(how many times G appears in Field D) = ABC8

strictly for illustrations sake.

I hope I explained that well.

Thanks in advance!

joshuaburkhow · Accepted Answer

You can do it something like this...

fmvizcaino · Accepted Answer

Hi @ZoeM ,

Pretty much the same idea if you want to find how many times the number 1 appears in [D].

[A] + [B] + [C] + ToString(REGEX_CountMatches([D], '1', 1))

Best,

Fernando Vizcaino