News for hackers. Stuff that matters.

A comment on Ask HN: Massaging many client CSV/textfile to correct columns/format etc.?.

Re:Ask HN: Massaging many client CSV/textfile to correct col... by slater on Thursday February 08, 2024 @10:23PM (#39310996)
Can you provide a few examples of these different files?
[ Parent | on HN ]
Re:Ask HN: Massaging many client CSV/textfile to correct col... by ryncewynd on Thursday February 08, 2024 @10:34PM (#39311068)
For a very basic example, lets say I want 3 columns

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

[ Parent | on HN ]