Regex_Needed1

[Kuldeep_Pandey]

Hi Team
Aláírás nélkül érvényes számlakivonat!
Amennyiben a Bank részére korábban, az ügyfél-azonosítás során megadott adataiban, illetve a tényleges tulajdonos személyét illetően változás történt, arról kérjük, Bankunkat haladéktalanul értesítse

8. Könyvelési dátum 9. Közlemény 10. Értéknap 11. Összeg

Start Balance 203.394.310,66
12. Jóváírások összesen 13. Terhelések összesen 14. Záró egyenleg

87.691.751,00 3.738.382,00 287.347.679,66
Text in Deutsch

I want to extract two amount from these text 1 .After start balance 203.394.310,66
2 no 287.347.679,66 please make this extraction as dynamically

[vrdabberu (Varunraj)]

Hi @Kuldeep_Pandey

USE THE BELOW REGEX EXPRESSION

System.Text.RegularExpressions.Regex.Matches(input,"(\d{3}\.\d{3}\.\d{3}\,\d+)")

OR CAN USE THE BELOW REGEX EXPRESSION

System.Text.RegularExpressions.Regex.Matches(input,"(?<=([A-Za-z]+\s+[A-Za-z]+\s+))(\d+.\d+.\d+.\d+)|((\d+.\d+.\d+.\d+$))")

Hope it works!!

[mkankatala (Mahesh Kankatala)]

Hi @Kuldeep_Pandey

Check the below regular expression

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=[\w+\s+\w+\s*])\d{3}\.\d{3}\.\d{3}\,\d+)”)

Hope it helps!!

[pravallikapaluri]

Hi @Kuldeep_Pandey

or

[Kuldeep_Pandey]

Please provide me 2 different regex
for 1 and for 2 amount both

[pravallikapaluri]

@Kuldeep_Pandey
Check my solution

[Kuldeep_Pandey]

Yes but in 2 Regex I want last amount

[mkankatala (Mahesh Kankatala)]

Okay @Kuldeep_Pandey

After Start Balance

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\w+\s+\w+\s*)\d{3}\.\d{3}\.\d{3}\,\d+)”)

Last number

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\d{1}.\d{3}\.\d{3}\,\d+\s*)\d{3}.\d{3}\.\d{3}\,\d+)”)

Hope it helps!!

[vrdabberu (Varunraj)]

@Kuldeep_Pandey

Hi @Kuldeep_Pandey

USE THE BELOW REGEX EXPRESSION

System.Text.RegularExpressions.Regex.Matches(input,"(\d{3}\.\d{3}\.\d{3}\,\d+)")

OR CAN USE THE BELOW REGEX EXPRESSION

System.Text.RegularExpressions.Regex.Matches(input,"(?<=([A-Za-z]+\s+[A-Za-z]+\s+))(\d+.\d+.\d+.\d+)|((\d+.\d+.\d+.\d+$))")

Hope it works!!

[pravallikapaluri]

@Kuldeep_Pandey

[mkankatala (Mahesh Kankatala)]

I have provided the regular expression to extract the values with different regex.

Check the above replies

Regex_Needed1

Okay @Kuldeep_Pandey After Start Balance System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\w+\s+\w+\s*)\d{3}\.\d{3}\.\d{3}\,\d+)”) [image] Last number System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\d{1}.\d{3}\.\d{3}\,\d+\s*)\d{3}.\d{3}\.\d{3}\,\d+)”) [image] Hope it helps!!

If you got the solution for your query. Make mark it as solution to close the loop. @Kuldeep_Pandey

[Anil_G (Anil Gorthi)]

@Kuldeep_Pandey

Try this

1. (?<=Start Balance )[\d,\.]+
   Uploading: IMG_6087.jpeg…
2. For the second can ypu say if there is any static text beside it? I see few using closing balance…if that is static then follow below
   (?<=Closing Balance\s+)[\d\., ]+
   
   
   
   fter getting the data split it with space and get the last value…str.Trim.Split({" "},stringsplitoptions.None).Last

Cheers
A

[vrdabberu (Varunraj)]

Hi @Kuldeep_Pandey

Below is the regex for your requirement. Please do check and let me know if anything required.

Regex_Needed1

@Kuldeep_Pandey Hi @Kuldeep_Pandey USE THE BELOW REGEX EXPRESSION System.Text.RegularExpressions.Regex.Matches(input,"(\d{3}\.\d{3}\.\d{3}\,\d+)") [image] OR CAN USE THE BELOW REGEX EXPRESSION System.Text.RegularExpressions.Regex.Matches(input,"(?<=([A-Za-z]+\s+[A-Za-z]+\s+))(\d+.\d+.\d+.\d+)|((\d+.\d+.\d+.\d+$))") [image] Hope it works!!

If you find the solution please do mark as solution to close the loop.

Hope it helps!!

[Parvathy (PS Parvathy)]

Use the datatype System.Collections.Generic.IEnumerable(System.Text.RegularExpressions.Match)

Regards

[vrdabberu (Varunraj)]

@Kuldeep_Pandey

Bro use the below as the data type for the variable created.

System.Collections.Generic.IEnumerable(System.Text.RegularExpressions.Match)

Hope it helps!!

[Kuldeep_Pandey]

Used

[vrdabberu (Varunraj)]

@Kuldeep_Pandey

Please check the below attached image.

Hope it helps!!

[vrdabberu (Varunraj)]

@Kuldeep_Pandey

Bro remove the double quotes and place it again.

System.Text.RegularExpressions.Regex.Matches(PDF_1.ToString,"((?<=\w+\s+\w+\s*)\d{3}\.\d{3}\.\d{3}\,\d+)")

Hope it helps!!

[Kuldeep_Pandey]

[vrdabberu (Varunraj)]

@Kuldeep_Pandey

Bro please give the below syntax in the assign activity

System.Text.RegularExpressions.Regex.Matches(PDF_1.ToString,"((?<=\w+\s+\w+\s*)\d{3}\.\d{3}\.\d{3}\,\d+)")

If not please use the below activities to get the output

In pattern give the regex expression
In Text to search in provide the input file example PDF_1
Give the output variable in the First Match as you are extracting only one data from that regex.

Hope it helps!!