How do I loop for each item in Filecontents
Eg:
Input
“”,
“CUSTOMERS. ALL PARTS REMAIN THE PROPERTY OF UK Total VAT Amount £122.13”,
“”,
“TRUCKREPAIRS LTD UNTIL PAID FOR IN FULL. THIS IS YOUR”,
“”,
“ORIGINAL & ONLY INVOICE Invoice Total £732.77”,
“”,
“”,
“”,
“Reg. No. 10602802 England VAT No. 261600535”,
“”,
“Registered Office: UK Truckrepairs Ltd,
147a High Road,
Waltham Cross,
Herts,
EN8 7AP”,
“”,
“”,
“”,
I need - Invoice Total £732.77 as O/P , using assign activity
can you tell us more about
what data type it is and from which source the variable value is coming from. Thanks
Check the below regex:
Input = “”,
“CUSTOMERS. ALL PARTS REMAIN THE PROPERTY OF UK Total VAT Amount £122.13”,
“”,
“TRUCKREPAIRS LTD UNTIL PAID FOR IN FULL. THIS IS YOUR”,
“”,
“ORIGINAL & ONLY INVOICE Invoice Total £732.77”,
“”,
“”,
“”,
“Reg. No. 10602802 England VAT No. 261600535”,
“”,
“Registered Office: UK Truckrepairs Ltd,
147a High Road,
Waltham Cross,
Herts,
EN8 7AP”,
“”,
“”,
“”,
Output = System.Text.RegularExpressions.Regex.Match(Input,"(INVOICE.*\d+)").Value
Regards
Assign: InvoiceTotal = System.Text.RegularExpressions.Regex.Match(FileContents.ToString, "Invoice Total\s*\£\s*\d+\.\d+").Value
Input = {"",
"CUSTOMERS. ALL PARTS REMAIN THE PROPERTY OF UK Total VAT Amount £122.13",
"",
"TRUCKREPAIRS LTD UNTIL PAID FOR IN FULL. THIS IS YOUR",
"",
"ORIGINAL & ONLY INVOICE Invoice Total £732.77",
"",
"",
"",
"Reg. No. 10602802 England VAT No. 261600535",
"",
"Registered Office: UK Truckrepairs Ltd,
147a High Road,
Waltham Cross,
Herts,
EN8 7AP",
"",
"",
""}
Assign-> result = Input.Where(Function(x) x.Contains("Invoice Total")).FirstOrDefault()
FileContents: Data type: Array of String
then a LINQ Where can help
strFirstLine =
FileContents.Where(Function (x) x.Contains("Invoice Total £")).FirstOrDefault
and we can combine it with a regex to cutout more the detail part
EDITED: grammar and statement formulation
Please check the below flow:
Input = {"",
"CUSTOMERS. ALL PARTS REMAIN THE PROPERTY OF UK Total VAT Amount £122.13",
"",
"TRUCKREPAIRS LTD UNTIL PAID FOR IN FULL. THIS IS YOUR",
"",
"ORIGINAL & ONLY INVOICE Invoice Total £732.77",
"",
"",
"",
"Reg. No. 10602802 England VAT No. 261600535",
"",
"Registered Office: UK Truckrepairs Ltd,
147a High Road,
Waltham Cross,
Herts,
EN8 7AP",
"",
"",
""}
Assign-> Output= Input.Where(Function(x) x.Contains("Invoice Total")).FirstOrDefault()
Result= System.Text.RegularExpressions.Regex.Match(Output,"(?<=INVOICE\s)(.*\d+)").Value
Regards
strText =
(From s in FileContents
Where Contains("Invoice Total £")
Let m = Regex.Match(s, "Invoice Total.*")
Where m.Success
Select v = m.Value).FirstOrDefault
What if the Key name" Invoice Total" Is dynamic?
example, in some file its, “Invoice Total” and some file its “Total Invoice Amount”
System.Text.RegularExpressions.Regex.Match(FileContents.ToString, "(Invoice Total|Total Invoice Amount)\s*\£\s*\d+\.\d+").Value
Use the below syntaxes in Assign:
Assign activity-> Input = {"", "CUSTOMERS. ALL PARTS REMAIN THE PROPERTY OF UK Total VAT Amount £122.13", "", "TRUCKREPAIRS LTD UNTIL PAID FOR IN FULL. THIS IS YOUR", "", "ORIGINAL & ONLY INVOICE Invoice Total £732.77", "", "", "", "Reg. No. 10602802 England VAT No. 261600535", "", "Registered Office: UK Truckrepairs Ltd, 147a High Road, Waltham Cross, Herts, EN8 7AP", "", "", ""}
Assign activity -> Output = Input.Where(Function(x) x.Contains("Invoice Total")).FirstOrDefault()
Assign activity -> Result = System.Text.RegularExpressions.Regex.Match(Output,"(?<=INVOICE\s)(.*\d+)").Value
Input is of DataType Array(System.String). Output and Result is of DataType System.String
Regards
Hi,
This expression is giving me Null value!!
Because I have multiple words in pdf saying “INVOICE”
