Hi Community,

May i know how can i solve the extraction below using the regex based extraction? I want to extract for invoice due date and invoice term individually.

Sample 1)

Invoice Number Invoice Date Due Date Terms

Remit To 100 USD Remit To 200

XI 3849 30 MAR 2017 29 APR 2017 Within 30 days Due net

Sample 2)

Due Date 30 SEP 2017

Terms Within 30 days Due net

Sample 3)

Invoice Date Due Date Terms

30 MAR 2018 29 APR 2018 Not more than 30 days

Output Wanted (for Due Date)

Sample 1) 29 APR 2017

Sample 2) 30 SEP 2017

Sample 3) 29 APR 2018

Output Wanted (Terms)

Sample 1) Within 30 days Due net

Sample 2) Within 30 days Due net

Sample 3) Not more than 30 days

Many thanks again for the support.

Reuploaded with text file.

Term and Due Date.txt (566 Bytes)