Puzzle 18
[ Thanks again to Andy Schone, for coming up with this one. ]
Your manager interrupted your coffee & danish this morning to complain
that your CSV import script has stopped working. She is sure nothing
has changed, and implies that your script is somehow responsible for
a total breakdown in civil order in the western hemisphere!
On her way out of your cubicle she gives you the attached CSV file
and says "Make it work".
Quick inspection of the CSV indicates that the unnamed source for the
data file has in fact changed the structure of each row. Each row now
include middle names, sometimes.
Your task grasshopper is this:
1) Modify your script ( puzzle 17 ) so that it adds a Middle_name field
to your DBF if it does not already exist.
2) Modify your script so that the data from the new CSV is successfully
"imported" into your table. Careful. some records contain a middle
name, while others do not.
3) Make sure you "import" 100% of the available data in each row of the CSV,
placing each element into its correct field in your table.
4) As before prefix the name of your script with your initials, and attach
the exported version of your script here for our edification.
Hint: If the middle name is part of the record it is always the 2nd
field of the record.
[ Thanks again to Andy Schone, for coming up with this one. ]
Your manager interrupted your coffee & danish this morning to complain
that your CSV import script has stopped working. She is sure nothing
has changed, and implies that your script is somehow responsible for
a total breakdown in civil order in the western hemisphere!
On her way out of your cubicle she gives you the attached CSV file
and says "Make it work".
Quick inspection of the CSV indicates that the unnamed source for the
data file has in fact changed the structure of each row. Each row now
include middle names, sometimes.
Your task grasshopper is this:
1) Modify your script ( puzzle 17 ) so that it adds a Middle_name field
to your DBF if it does not already exist.
2) Modify your script so that the data from the new CSV is successfully
"imported" into your table. Careful. some records contain a middle
name, while others do not.
3) Make sure you "import" 100% of the available data in each row of the CSV,
placing each element into its correct field in your table.
4) As before prefix the name of your script with your initials, and attach
the exported version of your script here for our edification.
Hint: If the middle name is part of the record it is always the 2nd
field of the record.
Comment