I am having 2 pdf with different values i have to specially extract those two values

Help Studio
, , , ,
1

pdf2
pdf 1

from these 2 pdfs from 1st pdf i have extract procedure date and from second pdf procedure date no time value
anyone can please help on this how to write regex value to get the procedure date: and rocedure date no time: values

2

Hi @Badda_Hemantha

1st PDF value

Assign activity -> Input = "Account #: 931868
                            Age: 64
                            Procedure Date No Time: 4/2/2024"

Assign activity -> ProcedureDateNoTime = System.Text.RegularExpressions.Regex.Match(Input,"(?<=Procedure Date No Time\:\s+)\d+\/\d+\/\d+").Value.Trim()

2nd PDF value

Assign activity -> Input = "Procedure Date: 4/1/2024:36 AM
                            Date of Birth: 3/21/1963
                            Gender: Female."

Assign activity -> ProcedureDate = System.Text.RegularExpressions.Regex.Match(Input,"(?<=Procedure Date\:\s+)\d+\/\d+\/\d+").Value.Trim()

Regards

3

at a time, we have to search both pdf values. either procedure date: or procedure date no time:

4

Do you want to extract the value according to Procedure Date No Time or Procedure Date. If these are present you need to extract the values right @Badda_Hemantha

Please specify.
Regards

5

yes, but the problem is 2 pdfs are in the one folder we to read those 2 pdfs one by one in loop and we have to get the Date No Time and Procedure Date

6

Hi @Badda_Hemantha

will you have both the values in both the PDF present in the folder. Please specify.

Regards

7

in one pdf we are having Procedure Date No Time and
in another pdf we are having Procedure Date
but the 2 pdfs are in same folder

8

Hi @Badda_Hemantha

The below syntaxes should work

If
  System.Text.RegularExpressions.Regex.IsMatch(InputText,"(Procedure Date\:\s+)\d+\/\d+\/\d+")
Then
    Assign activity -> ProcedureDateNoTime = System.Text.RegularExpressions.Regex.Match(InputText,"(?<=Procedure Date No Time\:\s+)\d+\/\d+\/\d+").Value.Trim()
End If

If
  System.Text.RegularExpressions.Regex.IsMatch(InputText,"(Procedure Date No Time\:\s+)\d+\/\d+\/\d+")
Then
     Assign activity -> ProcedureDate = System.Text.RegularExpressions.Regex.Match(InputText,"(?<=Procedure Date\:\s+)\d+\/\d+\/\d+").Value.Trim()
End If

image
image893×1052 42.8 KB

If it matches, it will extract or it will proceed with further operations. Let me know if you have any queries

Regards

9

can you please send me condition value

10

@Badda_Hemantha

Conditions of 1st If:

If
  System.Text.RegularExpressions.Regex.IsMatch(InputText,"(Procedure Date\:\s+)\d+\/\d+\/\d+")
Then
    Assign activity -> ProcedureDateNoTime = System.Text.RegularExpressions.Regex.Match(InputText,"(?<=Procedure Date No Time\:\s+)\d+\/\d+\/\d+").Value.Trim()
End If

Conditions of 2nd If:

If
  System.Text.RegularExpressions.Regex.IsMatch(InputText,"(Procedure Date No Time\:\s+)\d+\/\d+\/\d+")
Then
     Assign activity -> ProcedureDate = System.Text.RegularExpressions.Regex.Match(InputText,"(?<=Procedure Date\:\s+)\d+\/\d+\/\d+").Value.Trim()
End If

Regards

11

can u try these patterns:
1- For “procedure date” (with time):

(\d{1,2}/\d{1,2}/\d{2,4} \d{1,2}:\d{2}:\d{2})

2-For “procedure date no time” (date only):

 (\d{1,2}/\d{1,2}/\d{2,4})