Getting specific data from string

Help Studio
,
1

The below transaction summary is part of a larger string acquired by using the ReadPDFText activity.
How do I use RegEx to identify the text between “Count Amount Debits Credits” and “This information is covered by the”, and then assign it to its own variable.

All lines are static except the actual amounts and there is additional text in the string before and after what is provided.

Transaction Summary

Count Amount Debits Credits
284 $0.00 $332,853.89 -$332,853.89

This information is covered by the

2

Hi @mbuehler

Can you provide your Input and expected output so it’s easy to understand.
Regards,

3

Hey @Parvathy,

The input is:
Transaction Summary

Count Amount Debits Credits
284 $0.00 $332,853.89 -$332,853.89

This information is covered by the

The expected output:
284 $0.00 $332,853.89 -$332,853.89

4

You can use this regex:

(?!Count Amount Debits Credits\n).+(?=\n\nThis information is covered by the)

image
image815×331 20 KB

5

Hi @mbuehler

Use the following Regex expression:

[\d](.*)

image
image1413×497 17.3 KB

After extraction of the amounts I have used Split method to separate the values.
Note: Shared the workflow for better understanding and reference.

2.xaml (9.1 KB)

Hope it helps!!
Regards,