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!
Data formatting?
Moderator: General Moderators
- AbraCadaver
- DevNet Master
- Posts: 2572
- Joined: Mon Feb 24, 2003 10:12 am
- Location: The Republic of Texas
- Contact:
Re: Data formatting?
Lot's of Linux users so you'll have to paste a subset of the files instead of an .xlsx.
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Re: Data formatting?
Will post a CSV 