Count in a Concatenation Field

[ZoeM]

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!

[KP_DML]

this formula will work for the example given. The third parameter for REGEX_CountMatches sets whether it is case-sensitive or not.

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

[joshuaburkhow · Accepted solution]

You can do it something like this...

[ZoeM]

I developed the new fields. 

What I need now is the sum of '1' occurrences concatenated to the A, B, and C? 

[fmvizcaino · Accepted solution]

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