I need to have a specific name of a box truncate into 1. The text between is the name of the box with the type of alert like disk space.
load subfield([Sent By], 'specificname*Disk_Space*', 1), If(WildMatch([Sent By], '*specificname*:Disk_Space*'), TextBetween ([Sent By], 'specificnamewithnumbers*','')) as [specificname Disk Space],
so basically here is what I see the xx's are for security
multiple entries
PROBLEM -xxxxxxxx123: Memory is CRITICAL (FreeMemory=5%)
PROBLEM -xxxxxxxx123: Memory is CRITICAL (FreeMemory=6%)
PROBLEM -xxxxxxxx123: Memory is CRITICAL (FreeMemory=7%)
so these are all the same problem only with different memories moving up or down. I would like for them all to display as one entry.
