Extract Few Values From TextFile

Hi,

i want to extract few values for the fields from the attached text file

  1. Invoice No.
  2. VAT No:
  3. BANK NAME
  4. BANK ADDRESS

Thanks

SALES INVOICE

R   Europe Ltd 

Tech Company Pvt Ltd

2 London Bridge

Lautrupvang 2

London

2nd Floor Invoice No.

21290A

SE1 9RA

Ballerup
Tax Point

25 Jun 2018

2750
P.O.number

POBRS-

T: +44 (0) 20 7288 6637

Denmark
Page

0000115013

F: +44 (0) 20 7692 0552

Page 1 of 1

E: finance@rrecruitment.com

For the attention of:- Emily

W: www.rrecruitment.com
Tseng

VAT No:DK29182361

Units

Rate

Sub Total

For the services of:-

Alayo Andyriwa FROM 05 May 2018 to 09 May 2018

5.00 1,020.00 6,000.00
4.00 Days @ Euros 1,020.00 Pay & Charge rate

Net 6,000.00

Payment Due 30th of the month

VAT @ 0% 0.00

Total Euros 6,000.00

This supply is subject to the reverse charge

Please submit payment directly to our Euro Bank Account :
BANK NAME Barclays Bank plc BANK ADDRESS READING 9, Leicester, Leicestershire,
LE87 2BB

ACCOUNT NAME R Europe Limited ACCOUNT NUMBER 63537077 SORT CODE 20–71–14
IBAN GR72 BARC 2071 1443 5370 SWIFT/BIC BARCGB22
77

If any sums payable under this Agreement by the Client are in arrears by more than 14 days of the due date, then RIZE may
ch

You can try with “match activity” before you must study about RegEX

Hello @avinashy
If your text is going to be in this format than you can use Regular Expression or regex to get that data.
Regex is a sequence of symbols and characters expressing a string or pattern to be searched for within a longer piece of text.
You can learn more about regex by doing a simple web search
Back to your issue you can use Matches Activity to get all the data and by using this regex pattern
(?<=Invoice No.)\n\n.+|(?<=VAT No:).+|(?<=BANK NAME)\s\w+\s\w+|(?<=BANK ADDRESS ).+\n.+\s+
Check this workflow for better understanding
RegexTest.xaml (8.2 KB)

2 Likes