You are viewing limited content. For full access, please sign in.

Question

Question

Zone OCR mixing Date values

asked on October 1, 2018

Hi, I have placed a photo below with the Date I am trying to use Zone OCR to extract from an invoice. Now, the Zone OCR is working normally and formats the date like dd/MM/yy although the date on the invoice is printed as the year first, then month, then day. Meaning the 18 in the picture is actually the year and 12 is the day of the month. But even when I try changing the format with a token or reassigning a format to the OCR it still makes 18 set to the dd value. I am unsure how to tell the Zone OCR to read it as the 18 is the year and the 12 is the day of the month. 

Hoping someone might have some suggestions?

 

Thanks,

 

James

 

0 0

Answer

SELECTED ANSWER
replied on October 1, 2018

You can use the Substitution process to fix things up.



Replace Regex: (\d\d)\s(jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)\s(\d\d)

With: ${2} ${3} ${1}

This results in sep 12 18 which Quick Fields will be able to turn into a valid date. You might need to tweak that regex to more closely fit your dates. I just threw it together off the top of my head, so I don't know if the numbers in your dates can be one digit.

1 0
replied on October 1, 2018

Thanks, worked like a charm! I'll have to remember this if I come across this again.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.