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

Question

Question

Trying To Reconstruct Date In Text Field

asked on September 14, 2017 Show version history

I have a client that was using zone OCR to pull date information from invoices.  The field type that was created for this was Text.  They have now expressed a desire to pull the information from a UPC code.  I have extracted the data from the UPC code and created 3 tokens from it %(Month) %(Day) %(Year).  I can insert all 3 tokens into the text field with any character except the "/" (Division Symbol) and the date information is displayed correctly.  When using the division symbol the month is displayed correctly but day and year are not.  This is what it ends up looking like 08%(Day)%(Year).  Is there any way to insert the "/" symbol and not have it evaluate?

 

Any insight into this would be greatly appreciated

0 0

Replies

replied on September 14, 2017

See the help file. The slash is a special character. Use 2 of them to reconstruct your date to indicate it should be treated as a literal slash: %(Month)//%(Day)//%(Year). 

1 0
replied on September 14, 2017

Thanks.  That did the trick.

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

Sign in to reply to this post.