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

Question

Question

Trying take a pattern to take the 0 off the check number in QF

Quick Fields Version 10 Pattern Matching and Regular Expressions
Updated March 15, 2019
asked on March 14, 2019

I'm in need a better pattern for my QF session. I have one to pull the check number and to get 7 #'s but I only need the last 6 numbers. Here is the picture of the session. So I had changed it to a 6 but it took off the last number how do I get it to take off the first one?  

0 0

Answer

SELECTED ANSWER
replied on March 15, 2019 • Show version history

OCR sometimes will read a 0 (Zero) as an O (Upper Case Oh) or an o (Lower Case Oh) so you could try a pattern like

[oO0](\d{6})

The pattern accepts o (Lower Case Oh),  O (Upper Case Oh), or 0 (Zero) before a 6 digit number.

1 0

Replies

replied on March 14, 2019 • Show version history

Use the pattern \d(\d{6}) to remove the first digit. If you want to make sure the first digit being removed is a 0 you can use the pattern 0(\d{6}).

1 0
View 3 previous replies
replied on March 14, 2019 • Show version history

Hi Michael,

 

Thank you so much that helped. I used the first pattern the second one wasn't given me any numbers when I tested itsmileyyes Thank you for the fast response. Have a wonderful rest of your day.  

0 0
replied on March 14, 2019

I will save your comment for future in case. smiley Any question do they have area's were we can get general patterns at? 

0 0
replied on March 15, 2019 • Show version history

I know it is a bit old, but I have https://www.laserfiche.com/support/webhelp/quickfields/8.3/en-US/quickfields8_Left.htm#CSHID=Regular%2520Expression%2520Reference.htm|StartTopic=Content%2FRegular%2520Expression%2520Reference.htm|SkinName=Default

 

Also the little icon next to the pattern in the pattern matching does have drop downs for different items.

1 0
replied on March 15, 2019

Good morning Michael,

Thank you I will looking into it. Now after I had put that updated pattern it won't read the checks after it reads the one. So I reached out to my IT to figure why the pattern broke another thing. But it does take off the 0 lol. Have a great day and weekend. smiley

0 0
SELECTED ANSWER
replied on March 15, 2019 • Show version history

OCR sometimes will read a 0 (Zero) as an O (Upper Case Oh) or an o (Lower Case Oh) so you could try a pattern like

[oO0](\d{6})

The pattern accepts o (Lower Case Oh),  O (Upper Case Oh), or 0 (Zero) before a 6 digit number.

1 0
replied on March 15, 2019

I will try that one as well and see if it fixes my other problem as well. I will post and let you know what happens with this pattern. Thank you for your help as well. 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...