Data analysis post-translation with a regex string searcher.

Hey, i'm not 100% sure what you're asking here. Is it how to extract the central numbers from the filename column?

more or less, so it searches for all issues that are from each discipline and counts / summaries them (the discipline is given by the three letters within the filename string hence the string searcher).

you can use the following regex to pull out the middle three values:

-(.{3})-

Note, it will ONLY match when there is exactly 3 values. Here are some examples:

https://rubular.com/r/ub4uRE17UcI09b

Thanks for the reply, I don't think that's quite what I'm after.

Let me rephrase for a single case and I can scale it up.

Count all that satisfy '123' and Error 1 = YES and sum them. This would be fairly trivial in excel.

Right, I follow. In your original picture, you're close, I imagine the part your missing is in the statistics calculator, you want to set your group by attributes to "Error 1" and "_fist_match" (the attribute from the string searcher with the '123'). Then if you're just wanting the count, you can chose any attribute for the Statistics to Calculate attribute and check Total Count.

Group By is a very powerful, but potentially confusing feature of many transformers - theres a good help doc here: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Group_Based_Transformers.htm