Plese guide me about extract multiple matchs

I want to extract multiple matchs ( Account Code) in excel seperate column.

Account Code.pdf (155.0 KB)

Please guide me about it.

Hi @fairymemay,

Use this patern —> "(?<=Account Code:).*"

image

Follow the steps below

  1. First of all, you have to use read pdf text to get pdf text in string var —> Text1 (O/P var of read pdf text - String)
  2. Then you can use this in assgin activity,
    MatchesAcc = System.Text.RegularExpressions.Regex.Matches(Text,"(?<=Account Code:).*")
    here MatchesAcc is should be type of MatchCollection.
  3. You can use for each on MatchesAcc to make use of those matches.
    for each activity’s type argument should be System.Text.RegularExpressions.Match, then you can use item in your further sequence or for testing use message box with value item.
1 Like

@fairymemay

Check AttachmentBlankProcess12.zip (19.3 KB)

Hope this helps

Thanks

@ksrinu070184 @samir

If I want write account code in excel as below.

image

Please guide me about it.

@fairymemay

Check attached, This will write account code side by side

BlankProcess12.zip (174.9 KB)

Mark as solution, if this helps you

Thanks