Extract a substring from a table cell

  • 579 Views
  • Last Post 11 April 2019
  • Topic Is Solved
Antal posted this 15 March 2017

Hi,

I have some invoices from that i need to extract a substring of data from a cell, it has the same format, it is always a few digits, then a space and a few more digits. I would like to extract the data before the space, is it possible?. i`m using standalone version. Attached image.

Thanks

Attached Files

Order By: Standard | Newest | Votes
Ekaterina posted this 16 March 2017

Hello,

Yes, you may do it. You may take all cell’s value as string and extract the desired data as substring by auto-correction in the Document Definition level, Field properties (Using scripts in ABBYY FlexiCapture > Scripts for customizing processing stages > Types of scripts > Autocorrection script).

Ola Thuresson posted this 15 March 2018

Hello,

 

When using autocorrection script how can I access the vendorid? like this doesn't work?

string paramVal = Documents[i].Properties.Get(@"fc_Predefined:InvoiceVendorId");

or is there another way?

 

Regards,

Ola

Tson

Ekaterina posted this 19 March 2018

Hello,

The autocorrection script does not work with another fields or registration parameters directly. To access the vendorid and adjust the field value accordingly, please use event handlers scripts or script stages.

the VendorID field address would be

@"Invoice Layout\Vendor\VendorID"

  • Liked by
  • Ola Thuresson
Ola Thuresson posted this 19 March 2018

Thanks! I have put the autocorrection in the rulscript using the context.field(”vendorId”).text syntax

Tson

Ritesh Jain posted this 22 February 2019

Hi Ekaterina,

 Can you please give me more information on this? on how to achieve this? I have gone through the 5 day ABBYY training but we did not touch this. Any documentation on this will be helpful.

 

I am also looking to extract a substring from a table cell. I have clear identifiers to extend the substring, just not aware of how it can be done in abbyy.

Ekaterina posted this 11 April 2019

Hello,

You may see more details about autocorrection script in this article http://help.abbyy.com/en-us/flexicapture/12/developer/script_conversion

To get more accurate advice could you please describe your difficulties more clearly (what did you do step-by-step and what results did you receive) or you may address your question to your regional support

Close