Inconsistent Regex Behavior
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-08-23 10:39 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-08-23 11:58 PM
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?
If I answered your query. Please mark it as the Best Answer
Harish Mogulluri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-08-23 08:59 AM
if possible can you share the screen shot of your logic and logs?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-08-23 10:24 AM
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.
Amlan Sahoo
