Delimit Text File
I have a text file and need to split data into separate columns.
Ex columns:
First Middle Last Month Day Year Comments
Ex text:
Blue Bennett 11-4-99
Skip Malpass 11-4-99
Buffy Ruud 11-4-99
Rosco Berta 11-4-99 I wanted you to know that Roscoe way my heart and he still is. He is missed very very much… I just would like to know what it was that hurt him so bad that he didn’t wake up from the anesthesia? Do you have any answers? I cry every night for him. I had Roscoe since he was 3 weeks old. It was a big shock to everyone because Roscoe was so healthy … I just never thought my baby would leave me so soon! I haven’t been the same since.
Savannah Gellatly 11-4-99
Abagail Richey 11-5-99
Not all entries will have comments.
Not all entries will have first, middle, last names
Some entries may have more than first, middle, last (ex. Billy Bob Joe Thornton)… in these cases the names will have to be fit into first, middle last (Example First: Billy Bob, Middle: Joe, Last: Thornton)
Deliverable in | delimited or excel file.
Text file attached.
