I've made a program that creates and builds a variety of spreadsheets with customizable dimensions etc..... for things like.
Price lists and recommended retail prices.
Anyways i had no trouble creating that program but now i'm stuck with a simple problem thats annoying me!
So the program has the option to view the spreadsheet, search for items in the spreadsheet. and edit it and add items to it.
But to do any of that i need to know how to process the text files the spreadsheets are saved in.
They can be build with lines.
|Items |Price |Qty |Total |
|---------|-------|------|-------|
|Mum |2.22 |4 |8.88 |
|Dad |2.22 |4 |8.88 |
|----------|-------|------|-------|
Grand Total |17.76| |
Or without lines
Items Price Qty Total
-----------------------------
Pencil 0.55 10 5.5
Pen 1.23 10 12.3
-----------------------------
17.8 |
Um they line up perfectly in consoles font.
Edit:Wait it''s not the font i think the site is resizing it.
Anyway the numbers in them are separated by whitespaces and this strange symbol i don't know the name of "|" That one.
So how would i go about separating all the floating point numbers and strings?
I've already Processed each line to a string which is in a array.