Data formatting?
Posted: Thu Feb 04, 2010 8:43 am
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!
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!