I've been using this file-format below as an alternative for flat-text files, and I'm wondering if there is a name for it...
Say you have this data in a CSV:
FirstName,LastName,Email,UserName,Notes Bob,Smith,email@example.com,bsmith,Bob likes chicken John,Doe,firstname.lastname@example.org,jdoe, Steve,Jobs,STEVE@apple.com,STEVE,Steve Jobs likes things that start with "i"
In this "other" file format, there are 3 columns:
- Unique ID
- Attribute Name
The above data would look like this:
email@example.com,FirstName,Bob firstname.lastname@example.org,LastName,Smith email@example.com,Email,firstname.lastname@example.org email@example.com,UserName,bsmith firstname.lastname@example.org,Notes,Bob likes chicken email@example.com,FirstNameJohn firstname.lastname@example.org,LastName,Doe email@example.com,Email,firstname.lastname@example.org email@example.com,UserName,jdoe STEVE@apple.com,FirstName,Steve STEVE@apple.com,LastName,Jobs STEVE@apple.com,Email,STEVE@apple.com STEVE@apple.com,UserName,STEVE STEVE@apple.com,Notes,Steve Jobs likes things that start with "i"
I actually delimit on tab, but comma is easier to read for this. And in this example, any of the attributes could be used as a unique identifier.