Programming Puzzle 19 - Import Madness #3

[Tom Cone Jr]

Your manager is impressed with how well you're getting on. She has another "little project" for you.

Modifying Imported Data

The data imported in Import_Madness 1 needs to be corrected before we can do a mass mailing.

The original data was submitted as a mix of upper case and lower case values.
The lower case characters need to be converted into upper case.

Punctuation was also included in the import. All puncuation characters need to be removed.

For example
Before: 21 Porter St.
After: 21 PORTER ST

Also an error was made during the intial field size generation.
The Zip code needs to be resized to handle 15 characters.

Your assignment, grasshopper, is to write an xbasic script that will process the original CSV text file, importing the field values into a table, while at the same time cleaning up the data, as described above.

Post your solution using an "exported" version of your script. As before, please prefix your script name with your initials.

Good luck, and have fun.

-- tom

PS - Thanks again to Andy Schone for this puzzle.

[Tom Cone Jr]

Here's my solution.

Are there better approaches?

-- tom

[aschone]

I originally wanted to force the capitalization via field rules. Even had the rules editing portion of the script completed. Only problem was when I was writing the data to the table via <tbl>.enter_begin(.t.) the capitalization field rule was not being enforced. So with shame I hang my head and use a different approach.