topic Inconsistent Regex Behavior in Product Forum

Inconsistent Regex Behavior

LeoLugo — Tue, 29 Aug 2023 21:39:57 GMT

My process does the following

Pulls a value in from Excel as text.
Checks if the value matches the Regex pattern "^\d{3}$" using the Test Regex Match action.
Makes a decision based on the Matched? output of the action.

I'm trying to make sure the field contains 3 characters that are numbers i.e. "123", When I run in debug the action behaves as expected. When the process is ran from Control Room it randomly matches 2 digit text such as "30" or "17". The issue is inconsistent. During the same run, text such as "55" will fail to match which is what I expect. Does anyone have any insight as to why this might be happening?

Re: Inconsistent Regex Behavior

harish.mogulluri — Wed, 30 Aug 2023 22:58:50 GMT

Hi Lee Lugo,

Did you get chance to check in the logs? and see whether the data is adding "0" either at the beginning or ending?

Re: Inconsistent Regex Behavior

DevendranVenkatesh — Thu, 31 Aug 2023 07:59:54 GMT

if possible can you share the screen shot of your logic and logs?

Re: Inconsistent Regex Behavior

_Amlansahoo — Thu, 31 Aug 2023 09:24:12 GMT

Hi Leo,

I hope you are using AVO Regex for your use. If not download it from DX portal that is most recommended VBO for regex.