Data formatting?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dfbrand
Forum Newbie
Posts: 3
Joined: Thu Feb 04, 2010 8:07 am

Data formatting?

Post 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!
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: Data formatting?

Post by AbraCadaver »

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.
dfbrand
Forum Newbie
Posts: 3
Joined: Thu Feb 04, 2010 8:07 am

Re: Data formatting?

Post by dfbrand »

Will post a CSV :)
Post Reply