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

Question

Question

Remove the dollar sign in QF/WF

Quick Fields Workflow
Updated July 26, 2021
asked on July 26, 2021

I'm in Quick Fields. I have an OCR zone that will pick up a region that is an amount in which it will pickup  the dollar sign along with the digits. Ex. $2,419.80, $342.30, and/or $74,329.90. How do I set it up to remove he dollar sign in Quick Fields Token Dialog. I only want to see 2,419.80, 342.30, and/or 74,329.90

0 0

Replies

replied on July 26, 2021

If you have pattern matching with Quick Fields you can use the pattern [$|]([^$]*) and assign the token to the token of the pattern. You may also be able to use that as the Apply Regular Expression in the Token Dialog.

1 0
replied on July 26, 2021

In the token dialogue apply the pattern [\d,]+\.\d\d

This will exclude any unwanted characters

\d is any digit character

[\d,]+ is any digit characters or commas

\. is a period character

1 0
replied on July 26, 2021

Sweet, thanks Guys!!!!

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

Sign in to reply to this post.

Details
Related Posts
Loading ...