Hi,
I have attached a file with two tabs. The 1st tab is the data which needs to be parsed. The 2nd tab is the format which I expect to see.
I don't know how to parse the data which was truncated into 2 lines.
Your help would be greatly appreciated.
Mary
This will be challenging to do in a dynamic way, such as the next time you read in a similar document. There’s lots of additional white space which needs to be cleaned up.
Depending on the format of the data in the PDF, such as is it already in a table, I’d suggest using the table detection option in the image template tool. This would give you an output field with the columns delimited by a ‘|’ (pipe delimiter), which would make parsing easier and a more consistent approach.
User | Count |
---|---|
59 | |
26 | |
25 | |
22 | |
21 |