Hey all. I have a program that outputs the data in a fashion that makes it hard to use without the graphics, this in turn makes it hard to convert to a usable CSV.
I was wondering if you guys could help think of a way to reformat. The fun thing is the headers for the data also does not always line up
You want us to think about what you may want ?
Sorry let me rephrase: Help me figure away to remap the data to a standard CSV format. I am needing the headers to be in line
Such as:
Receipt Number Trans Type Transaction Total Tender Amount Receipt Date Trans Code SKU Description Qty Price Tax Discount ItemTotal
Ok - but how do you get these data into your sheet. Looks a bit like “Mark everything in the application GUI and paste what could be put to clipboard into LO”
My data source is a horrid POS system that outputs the attached file. It is more or less replicating the look of a receipt and outputting it in xls (attached), PDF, RPT or a Doc. It has a crystal report backend that I can not attach to. The reports are predefined, it is more or less what you get is what you get.
This sounds like the task “convert unstructured data to structured ones”. I’ve got no idea
And also this data seems to have a one-to-many data structure, which can not be converted to a one-dimensional table like a csv file is. So far I don’t have an idea too. Could you please tell us something about your objective? What is the csv file for or how do you want to process the data then?