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,firstname.lastname@example.org,bsmith,Bob likes chicken John,Doe,email@example.com,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:
firstname.lastname@example.org,FirstName,Bob email@example.com,LastName,Smith firstname.lastname@example.org,Email,email@example.com firstname.lastname@example.org,UserName,bsmith email@example.com,Notes,Bob likes chicken firstname.lastname@example.org,FirstNameJohn email@example.com,LastName,Doe firstname.lastname@example.org,Email,email@example.com firstname.lastname@example.org,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.