Adding fixed character in field based on condition.


I have a field here where I'm extracting the expiration date. I have no problem with the extraction. But I want to do the following:

Actually if the expiration date doesn't follow this regex ([١٢٣٤٥٦٧٨٩٠‎]{4}"/"[١٢٣٤٥٦٧٨٩٠‎]{2}"/"[١٢٣٤٥٦٧٨٩٠‎]{2}) it will raise a warning flag.

So since I have problem when it extracting the last digit from the right in the year part as shown in the images bellow where the character (١) is missing from some documents + it's almost a fixed character.

I want to do the following:
- If the document has a warning, then directly add the character (١) in the (Expiration Date) field, So instead of having (٤٤٠/١١/٠٢), it should be (١٤٤٠/١١/٠٢).

Any solution provided will be fine, but can we implement this with auto-correction script?

Thanks in advance.

Was this article helpful?

0 out of 0 found this helpful



Please sign in to leave a comment.