List almost-duplicates (in a variable?)

[djm229]

Hello.  I have a search that results in, amongst other things, fields that are ALMOST duplicates.  Example:

Bob: Task incomplete.

Steve: Task Incomplete.

George: Task Incomplete.

Fred: Task Complete.

Spock: Task Complete.

Is there a way to generate a table which results in:

| Task Status           |  Team Player Responsible |

| Task Complete    |  Fred, Spock                            |

| Task Incomplete |  Bob, Steve, George              |

For each instance of "Task Complete" and "Task Incomplete", I want to know which Persons to tag in a simple table without listing every user in a giant list.

I've looked into dedup, uniq and sub-searches but haven't figured out how to list the non-duplicated parts next to a single instance of the duplicated part.

[Insert deity], I hope that made sense.  Help?

[scelikok]

Hi @djm229,

I assumed your usernames and task status is in the same field. If not rex command is unnecessary;

Please try below by updating your <your_field> with field that contains your sample values;

| rex field=<your_field> "(?<user>[^:]+):\s(?<task_status>.+)"
| stats values(user) by task_status

[djm229]

Thanks, I'll have to modify the regex to make it (and the rest of my query) fit together.  If it works, I'll tag as "the Solution".  Very much appreciate it - even if it doesn't work.