Need help with String Manipulation for extracting 1st and last column from a table in pdf

Help
1

I have a native pdf , having a table of 6 columns , from which i require 1st and last column in this format " Room & Nursing charges - Non payable items", i have already extracted the data in string format , can anyone help out with string manipulation or suggest me if anything else could be done.

image
image876×309 30.7 KB

2

Can you please tell us if you need only the rows having the Category as Room & Nursing Charges and the Reason as Non-payable Items? Or do you need the format: Column1 - Column2?

If you can provide your current string output, that would also make things smoother. :slight_smile:

3

stringFinal = strCategory + " - " + strReason

4

@KarthikByggari @q-z i want in this format Column1 - Column2?
The data which i have to manipulate is in this format as follows:

" Category Sub Category Requested Amount Approved Amount Deducted Amount Reason
Room & Nursing
Charges
Room & Nursing
Charges demo one
1600.00 0.00 1600.00 Non-payable Items
Room & Nursing
Charges
Semi-private room
charges
18000.00 13500.00 4500.00 rs.4500/- excess
room charges
deducted as per
tariff.
Investigation
Charges
Investigation
Charges demo nine
49310.00 47080.00 2230.00 Non-payable Items
Medicine &
Consumables
charges
Medicine &
Consumables
charges demo one
2974.00 2319.00 655.00 rs.280/- gloves ,
rs.170/- misc items ,
rs.205/- hand rub
charges not payable"

5

The data is not in particular format or pattern.
So, it is difficult to do string manipulations here.

So I recommend to get the pdf table into data table.
So it would be easy to apply string manipulations.

How to read pdf tables - please search in forum. There are numerous threads on this.

Regards,
Karthik Byggari