RegexMatch : Column manipulation – GQI query

Solved174 viewsColumn Manipulation GQI queries RegexMatch
1
0 Comments

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 Enabler] Selected answer as best 22nd October 2024

1 Answer

3
282 2 Comments

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 Enabler] Edited comment 22nd October 2024
Wale Oguntoyinbo [SLC] [DevOps Enabler] commented

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.
Willem Mélange [SLC] [DevOps Advocate] commented

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.