Extracting data from notepad

Help Studio
1

Hi Everyone

i have a notepad with the data
Account Number:786494623832

Bank: IDBI

Branch:MIYAPUR

Loan Taken On: 24-JAN-2004

Amount: 2500000

EMI(month): 6500

i want to get the acano,branchname,…

how to do that
can you please explain

2

HI @jayanthi_bureddy

(?<=Account Number:)(\d+)

(?<=Branch:)([A-Za-z]+)

(?<=Bank:\s*)([A-Za-z]+)

(?<=Loan Taken On:\s*)([A-Za-z0-9\-]+)

(?<=EMI.*:\s*)([A-Za-z0-9\-]+)

(?<=Amount:\s*)([A-Za-z0-9\-]+)

image
image813×516 21.1 KB

image
image903×533 23.5 KB

image
image992×605 26.8 KB

image
image1002×611 27.6 KB

image
image1113×621 28.3 KB

image
image1089×612 28.3 KB

Regards

2 Likes
3

Hi ,

You can use regex to get the desired result.

1 Like
4

Hi @jayanthi_bureddy

→ Build Data Table

image
image764×489 10.4 KB

Output-> dt_Output
→ Read Text File
Output-> str_Text
→ Use below syntaxes in Assign activity:

-> AccNumber= System.Text.RegularExpressions.Regex.Match(str_Text,"(?<=Account Number:)(\d+)").Value

-> Bank= System.Text.RegularExpressions.Regex.Match(str_Text,"(?<=Bank:\s*)([A-Za-z]+)").Value

-> Branch= System.Text.RegularExpressions.Regex.Match(str_Text,"(?<=Branch:)([A-Za-z]+)").Value

-> LoanTaken= System.Text.RegularExpressions.Regex.Match(str_Text,"(?<=Loan Taken On:\s*)([A-Za-z0-9\-]+)").Value

-> Amount= System.Text.RegularExpressions.Regex.Match(str_Text,"(?<=Amount:\s*)([A-Za-z0-9\-]+)").Value

-> EMI= System.Text.RegularExpressions.Regex.Match(str_Text,"(?<=EMI.*:\s*)([A-Za-z0-9\-]+)").Value

→ Add Data Row

ArrayRow-> {AccNumber,Bank,Branch,LoanTaken,Amount,EMI}
DataTable-> dt_Output

→ Write Range Workbook
Output:

image
image779×332 5.69 KB

Workflow:

image
image880×1025 59.9 KB

xaml:
Sequence28.xaml (14.1 KB)

Regards

2 Likes
5

If you have that data in notepad it means it’s a text file, so just use the Read Text File activity.

6

From given sample we assume that the data is within a key value structure, where : is a delimiter
So with some cleansings we can do

  • Dictionary creation

OR

  • parsing it within a KeyValue Structure DataTable with generate DataTable
  • Read CSV (when replacing : to another delimiter with Replace Method, done before)
    PLUS / Optional transponation to a ColName, ColValue Table

OR

  • using a generic Regex and transforming the result e.g. to another prefered structure / DataType:

grafik
Refering to the groups for Key, Value extraction from a match
grafik

1 Like
7

Thanks for you help

does we can’t able do with out using regex?

8

Hi @jayanthi_bureddy

As per your requirement it is good to go with regex expressions.

Regards

1 Like
9

Ok ,thanks for the help
it really helps me

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.