I have a text file that I wish to turn into a CSV. The pattern of its contents are as follows:
1 mm/dd/yyyy LastName, FirstName MiddleName ID-NUMBER-HERE GENDER 2 mm/dd/yyyy LastName, FirstName MiddleName ID-NUMBER-HERE GENDER
- Number's 1 and 2 are line numbering of each set. I want to remove it.
- The dates are birthdays. Is there a way to change it to another format?
- Names: What if the person have two (2) first names or have a prefix? I want them all in a single column. Same with middle names and last names.
The file is 26MB in size.
The resulting format that I want is:
Is there a way to do this with SED or other tools?
I just learned about SED and it would take me longer if I try to do it myself.
Can anyone help out?
I'm on a mac btw.
Thanks a lot!