How to generate data table from dynamic text (which has been extracted from PDF from table format)

Help
, , , ,
1

The following is the string extracted from the pdf.

Period Course ID Name Abbr Sem Course Grade Final Sem Credit P/F Expla- Teacher
Grades Avg Grade Seq Code nation
34564 Career Portals (First Time 2 94 96 96 0 0.0 XXX
Taken) 98
24345 English Language Arts, 1 86 89 1 0.0 xxx
Grade 7 93
46758 English Language Arts, 2 91 89 89 2 0.0 xxx
Grade 7 87
45436 Mathematics, Grade 7 1 75 72 1 0.0 xxx
72
46475 Mathematics, Grade 7 2 71 73 73 2 0.0 xxxx
77
46537 Music, Middle School 2, Choir 1 96 96 1 0.0 xxxx
95
2346622 Music, Middle School 2, Choir 2 76 88 92 2 0.0 xxx
100
7346467 Physical Education, Grades 7 1 100 100 1 0.0 xxx
-8 100

Actual Pdf table:

image
image775×260 32.5 KB

The values in this table changes dynamically sometimes its null in any of the columns.sometimes as values.
If Any one as any suggestions how to extract this to datatable??? please let me know.Thank you in advance.
Any help is really appreciated!!

2

Have you tried using generate data table activity with different delimiters @sinduRPA, try that, it will help you for sure :slight_smile: