Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Ask HN: Massaging many client CSV/textfile to correct columns/format etc.?. Parent comment
FirstName|LastName|Age
And client files look like
ClientA: First|Last|Age
ClientB: Age|FirstName|Last
CientC: FullName|Age
ClientD: DateOfBirth|First|Last
So they all have the required info, but some intervention is required.
Column matching/renaming
Column order
Splitting full name to first/last
Converting DateOfBirth to Age
There are no comments on this comment yet.
FirstName|LastName|Age
And client files look like
ClientA: First|Last|Age
ClientB: Age|FirstName|Last
CientC: FullName|Age
ClientD: DateOfBirth|First|Last
So they all have the required info, but some intervention is required.
Column matching/renaming
Column order
Splitting full name to first/last
Converting DateOfBirth to Age