I have a Text field with lots of data in each row
Sample 1
The disk F: on the computer is running out of disk space.
The values that exceeded the threshold are 4.46% free space and 958 free Mbytes.
Server: CHP13332.hosts.cld.com
Target: F:
Alert: Logical Disk Free Space is low
Alert Date: 2020-01-16T13:10:40.1230000Z
MORE TEXT...
Sample 2
The disk F: on the computer is running out of disk space.
The values that exceeded the threshold are 4.46% free space and 958 free Mbytes.
Server name: CHG15632.hosts.cld.com
Target: F:
Alert: Logical Disk Free Space is low
Alert Date: 2020-01-16T13:10:4otoiwetuq0Z
MORE TEXT...
I want to extract the Server name: CHP13332, CHG15632
The Server name starts with anything. It is always mentioned after the word "Server:" or "Server name:"
It is always mentioned after the ":" but there can be many ":" in the whole text
Please help
Solved! Go to Solution.
Hi @qlikvw2019,
Based on how you presented the data, this Regex parse works for both examples (same Regex tool set up for both. If all the data is in the same row it should still work.
Hello @qlikvw2019 ,
Maybe this works:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards