Regular expression - PDF Data Extraction

[Lalitha_Selvaraj]

Hi, I have attached the pic of pdf . I need to extract all the values by row by row. can anyone help on this.

Extracted Text file:
extracted text.txt (226 Bytes)
if there is no value, the expected output will be ^“”^“”^“”^“$”^“” Here the 2nd row and 3rd row doesn’t have any value. so it should print like this.

[lchirathapudi (Pallavi Chirathapudi)]

Hi @Lalitha_Selvaraj

Try this

Sequence7.xaml (23.7 KB)

Regards,

[Lalitha_Selvaraj]

Hi @lchirathapudi . Row 1 output should be like this “ST DAVID ## Yes ## No 123 $250,000 2015”. the entire row value should get printed .

[lchirathapudi (Pallavi Chirathapudi)]

@Lalitha_Selvaraj

How about the following?

Sequence7.xaml (23.7 KB)

Regards,

[Lalitha_Selvaraj]

Let me check and inform you back.

[Lalitha_Selvaraj]

Since Im not able to open the .xaml file. can you please send the pic of regex and variable types which you have used in the .xaml.

[lchirathapudi (Pallavi Chirathapudi)]

@Lalitha_Selvaraj

Check this

Pattern : "(.*Yes.*)"

Match = If(System.Text.RegularExpressions.Regex.IsMatch(currentMatch.ToString(), "(^[A-Z].*)"), System.Text.RegularExpressions.Regex.Match(currentMatch.ToString(), "(^[A-Z].*)").Value, "^""^""^""^""$^""")

Regards,

[Siddhesh_Sapkal1 (Siddhesh Sapkal)]

Try using Computer Vision(CV) Activities, use extract data for this type of texts.

[Lalitha_Selvaraj]

Hi. I dont find “find matching pattern” activity in activities panel.

[lchirathapudi (Pallavi Chirathapudi)]

@Lalitha_Selvaraj

Search Matches activity

Regards,

[Lalitha_Selvaraj]

Its working fine. can you pls tell how to print output values in csv file.

[lchirathapudi (Pallavi Chirathapudi)]

@Lalitha_Selvaraj

Output:

Regards,

[Lalitha_Selvaraj]

Please look into this

[lchirathapudi (Pallavi Chirathapudi)]

@Lalitha_Selvaraj

Place the Build Data Table activity above for each activity and check Include headers option

Regards,

[Lalitha_Selvaraj]

It’s working fine. Thanks.