Dojo,
I have this Regex expression that works ok in a test tool but does not work when I use it in my GQI query. I'm interested in matching ( hh:mm (AM/PM) ). Specifically the (AM/PM) is not returned. Any ideas ?
Wale Oguntoyinbo [SLC] [DevOps Advocate] Selected answer as best 22nd October 2024
Hi Wale, it seems that the RegexMatch in GQI only returns the first occurrence of the regular expression. Your regex has two occurrences in your example above. Do you really need to drop the seconds part in your example? I don't think that will be possible with only one regex expression since the value that is returned is the entire matched string.
Wale Oguntoyinbo [SLC] [DevOps Advocate] Edited comment 22nd October 2024
Hi Wale, in your example your regex has two matches, it matches on 9:45 and it matches on AM. However, in GQI only the first match is returned being 9:45.
Hi Willem, dropping the ‘seconds’ is more to declutter the column and make it look a bit cleaner as its not really needed. Your explanation however does explain why the AM/PM is not returned in the GQI. Thanks.