Welcome to Kofax RPA > Design Studio > Extract Content From an HTML Table > Handle Table Content Irregularities

Handle Table Content Irregularities

Cell content in the same table column may differ in format. For example, a cell can be empty, contain "Bob" (first name), or contain "Bob Smith" (first name and last name).

  1. To handle content irregularities, in the extraction step, add an If Then data converter.
  2. Configure If and Else If properties to match each format variation.

    The corresponding Then properties extract the matching subpattern.

    Note The Extract action only allows you to extract one value. In the "Bob Smith" case, which contains two values (first name and last name), you must create two steps: one that extracts the first name and one that extracts the last name. Both steps contain an Extract action with an If Then data converter so that the first step extracts the first name (if any), and the second step extracts the last name (if any).