I want to apply regex exp


I want sweep transaction and trn no from whole page how to get this

@Kuldeep_Pandey
Is these transaction details from a PDF file?

Hi @Kuldeep_Pandey

Can you share the sample Text here?

yes this is pdf file i want to extract these data

Hi @Kuldeep_Pandey

Can you send a the input as text file?

Regards
Sudharsan

D030059222230325 like this type of data from trn no

This not enough kindly share the full text including the space in the input file @Kuldeep_Pandey

HI @Kuldeep_Pandey

To extract TRN

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=TRN\sREF\sNO:)\S*").Tostring

Regards
Gokul

What is the Output for this? @Kuldeep_Pandey

is it will work in a loop and get all trn no and write into excel file

Yes @Kuldeep_Pandey , It will work if the Pattern match the input.

If you have different pattern we need to alter the expression.

I want top one transaction type whatever it is like sweep transaction and get outgoing

I can’t able to find the, Can you mark the output and share with us for sweep transaction? @Kuldeep_Pandey

Not an image file @Kuldeep_Pandey

Download a PDF package in your project

  • Use read pdf with text activity (Preserve format as true in the properties) and store in a string.

  • Use write text file and write them in a text file and send that text file here

Regards
Sudharsan

Here Instead of your string You need to give the Input value of the string that means, Read PDF Text activity Output variable @Kuldeep_Pandey

TRN REF NO:D03ZLQM22223000W
TRN REF NO:D03ZLQM2222300I1
and transaction type
SWEEP TRANSACTION

its not working in a loop

What is not working in the loop? @Kuldeep_Pandey , Share the screenshot of your flow