Hi. I am scraping unstructured data from pdf. However, I can separate it into rows by newline but i also want to separate into 4 columns: Details, Date, Amount. (don’t need column headers)
So I thought maybe can put into columns by characters e.g. first 100 characters into ‘Details’ Columns, last 10 characters into ‘Amount’ column.
But I not sure how to go about it. Or if you have any other ways, I am open to suggestions
This is the sample of the data
This is how I would like the output to look like
Thank you xoxo