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

Question

Question

Workflow: Pattern matching across multiple rows

Workflow
Updated February 2, 2016
asked on January 29, 2016 • Show version history

Need help with how to add data to my workflow. I want to capture the entire 3rd line of text in this block:

The first line is always consistent. Here is the section in Workflow Pattern Matching that I want to configure, and my unsuccessful attempt at isolating the text on the 3rd line. 

Please help! Thank you so much.

0 0

Answer

SELECTED ANSWER
replied on January 29, 2016

Im sure there are better options, but try something like this then trim it.

Soldto:\s+\d+\s+(.{40})

 

1 0

Replies

replied on February 2, 2016

Got it. Here are the patterns, which work since the text is gathered in one long batch during OCR.

...and here are the captured fields displayed in the Client:

Thanks for the help!

1 0
replied on January 29, 2016

... Also, line 3 has other text on it (farther across the page; before or after) so I want to recognize "SoldTo:" and then do two carriage returns, and then capture the first 40 character spaces. Is that reasonable?

0 0
replied on January 29, 2016

Still struggling to make it extract multiple values from the third line and keep the formatting.

0 0
replied on February 2, 2016

Here is a more realistic picture.

I need to capture both of these values with separate workflow elements. (3rd line value directly below "Soldto:" and the same with "Shipto:". The text is arranged in columns on the page, so treating it as a simple pattern does not work. Please advise.

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...