I am trying to convert a list of data into a database
My text after being converted back from a pdf image is no longer in
columns and grouped as so: FIRST_NAME LAST_NAME unique_identification#
dob(y-m-d) gender date_of_visit(y-m-d) billing_code(combination of
uppercase letters and numbers) procedure_performed(capitalized with
spaces between each word with a few upcase words) billed_amount(eg 35.20
or 123.40) nextFIRST_NAME LAST_NAME … and goes on and on for a
couple of thousand records.
I would like them all to be put into a spreadsheet like excel. How
should i divide up the data.
I’m thinking Assign classes but what are some conditionals that would
help me define the classes like first name, last name, billingcode… Am
i over thinking this? Is there an easier way to manipulate the data?
I’m in over my head and need a rubyist to set me on the right track on
how to manipulate & organize & import to excel.