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

Question

Question

Number field error

asked on December 7, 2022

I have a Quickfields session that pulls a number from Zone OCR. Substitution removes the dollar sign.

The field appears to have the correct information, but an error stating "The value can only consist of digits 0-9 and, optionally, a negative sign and/or a decimal point."

I can type in the exact information and it works.

Here is a flagged item.

Here is what happen when I type it in. It seems to validate.

Any ideas as to why this would be happening?

0 0

Answer

SELECTED ANSWER
replied on December 7, 2022

Likely OCR is picking up whitespace characters like the end of the line or a trailing space. Try running it through a Pattern Matching process to pull just digits. Something like [0-9\.\-]+ set to all matches with no spaces.

0 0
replied on December 7, 2022

That seemed to work. I just need to adjust it for larger numbers.

Thank you.

0 0
replied on December 7, 2022

you can also run a default substitution to remove any whitespaces that may have been pulled in. I have had a lot of success with that

1 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.