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

Question

Question

Regular Expression to only pickup specific characters

Quick Fields Pattern Matching and Regular Expressions
Updated April 17, 2018
asked on April 17, 2018

I'm creating a session in quick fields to simply pickup an ASN number from some BOLs and renaming the BOL document to that number.

The ASN is listed on the BOL as ASN #: 493020

I only want to pickup the 493020.  What would be the best expression to use to leave out the ASN #: as well as the space before the number?  Thank you.

0 0

Answer

SELECTED ANSWER
replied on April 17, 2018

You could use

ASN #: (\d+)

 

2 0
replied on April 17, 2018

Due to the low quality of some of the documents, some of ASNs are picking up without a space between ASN and # or with added other added or missing spaces, so it's not working for those.  Is there an expression that will ignore everything except numbers so that inconsistencies with the ASN #: wouldn't matter?

0 0
replied on April 17, 2018

Nevermind I think I have it.  Just using the (\d+) worked so far.  Thank you!

0 0
replied on April 17, 2018

That was my next offering. smiley

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.

Details
Related Posts
Loading ...