Hi everyone!
I'm having some trouble with a Regex Tool. Currently, the Regex Tool I configured extracts a number of a text, ignoring the A-Z characters, and the punctuation marks as well.
Here's the current configuration of the Regex Tool:
".(\d{8}.\d+)|.(\d{9})|.(\d{8})|.(\d{6})|.(\d{5})"
As you can see, the only numbers that will be parsed are the ones whose length is equal to 5, 6, 8 or 9.
However, there's a value that contains a 4-digit value I need to parse, but it also contains another 4-digit value that is related to the current year.
Here's an sample of the value I mentioned:
"hns-npazymin,13/1/2022 TMF TTG 3450 $50,00 C 0581982745 DAVE"
Does anyone know how I could parse the "3450" value, instead of "2022" value, without changing the current Regex Tool configuration at all?
Thanks!
