Page 1 of 1

Data formatting?

Posted: Thu Feb 04, 2010 8:43 am
by dfbrand
Hey Guys, Long time reader - first time poster!.

I have a link to a Domino database, but the data is in a really illogical format and I have no idea how I can go about formatting it! and then save it to a file, or insert it into an SQL database?
I know PHP isnt ideal for this but its the only language I know!.
the data comes in the format shown in the file http://rapidshare.com/files/345824462/what_I_have.xlsx (it doesnt paste correctly!)

as you can see there is the 'type', an ID, a model name and then a series of attribute fields (could be anything of about 100 things)
I am looking for a method to split this up by the delimiters - but the problem is, the asset could be anything in any order.

I have attached a second file to try and show what im trying to achieve
http://rapidshare.com/files/345824464/t ... hieve.xlsx

I really hope this makes sense!


thankyou so much in advance!

Re: Data formatting?

Posted: Thu Feb 04, 2010 10:34 am
by AbraCadaver
Lot's of Linux users so you'll have to paste a subset of the files instead of an .xlsx.

Re: Data formatting?

Posted: Thu Feb 04, 2010 10:49 am
by dfbrand
Will post a CSV :)

Re: Data formatting?

Posted: Thu Feb 04, 2010 10:54 am
by dfbrand