Machine derived contents note: Contents -- Introduction, xi -- Acknowledgments, xiii -- Chapter 1. Framing the Problem, 1 -- Chapter 2. Metadata, 11 -- Chapter 3. Object Modeling Your Data, 35 -- Chapter 4. Transfer and Conversion, 59 -- Chapter 5. Dealing With Raw Data, 73 -- Chapter 6. Character Mapping and Code Sets, 81 -- Chapter 7. Data Fields, 93 -- Chapter 8. Fields, Records, and Tables, 97 -- Chapter 9. Times, Dates, Schedules, and Calendars, 107 -- Chapter 10. Names, Addresses, and Contacts, 127 -- Chapter 11. Spatial Data and Maps, 139 -- Chapter 12. Paint Me a Picture, 157 -- Chapter 13. Roll Tape!, 165 -- Chapter 14. Rights Issues, 185 -- Chapter 15. Integrating with Enterprise Systems, 191 -- Chapter 16. Data Exchange Formats, 197 -- Chapter 17. XML-Based Tools and Processes, 213 -- Chapter 18. Interfaces and APIs, 233 -- Chapter 19. Scripting Layers, 247 -- Chapter 20. UNIX Command Line Tools, 255 -- Chapter 21. Power Tools, 263 -- Chapter 22. Automation with Shell Scripts, 273 -- Chapter 23. Automation with AppleScript, 281 -- Chapter 24. Script Automation in Windows , 287 -- Chapter 25. Compiled and Interpreted Languages, 299 -- Chapter 26. GUI Tools and Processes, 309 -- Chapter 27. Building Tools, 313 -- Chapter 28. Keep It Moving, 323 -- Chapter 29. Publishing Systems, 343 -- Chapter 30. Adding Intelligence and Metrics to Tools, 347 -- Chapter 31. Lateral Thinking, 353 -- Chapter 32. The Bottom Line, 359 -- Part 2. Tutorials, 365 -- Tutorial 1. Calling Shell Commands from AppleScript, 369 -- Tutorial 2. Calling AppleScript from Shells, 370 -- Tutorial 3. Calling Visual Basic from AppleScript, 372 -- Tutorial 4. Calling Visual Basic from UNIX, 373 -- Tutorial 5. Calling UNIX Shell Commands from C, 374 -- Tutorial 6. Calling Java from C Language, 375 -- Tutorial 7. Calling C from Java, 376 -- Tutorial 8. What Your Web Server Log Can Tell You, 377 -- Tutorial 9. Monitoring Your Operating System Logs, 378 -- Tutorial 10. Measuring and Monitoring Disk Usage, 380 -- Tutorial 11. Wrapping FTP Transfers in a Script, 385 -- Tutorial 12. Wrapping gzip in a Shell Script, 389 -- Tutorial 13. Many-to-Many Relationships, 390 -- Tutorial 14. Phonetic Searches, 391 -- Tutorial 15. Fuzzy Searching and Sorting, 393 -- Tutorial 16. Finding Buffer Truncation Points, 394 -- Tutorial 17. Cleaning Unstructured Data, 395 -- Tutorial 18. Sorting Out Address Data, 396 -- Tutorial 19. Time Data Cleaning, 400 -- Tutorial 20. Removing Duplicates, 401 -- Tutorial 21. Converting TSV to XML, 402 -- Tutorial 22. Removing Macros from Word Documents, 404 -- Tutorial 23. Removing all Hyperlinks from Word, 405 -- Tutorial 24. Recognizing U.S. ZIP Codes, 406 -- Tutorial 25. Recognizing UK Postal Codes, 407 -- Tutorial 26. Finding Variable Names in Source Codes, 408 -- Tutorial 27. Finding Double-Quoted Strings, 409 -- Tutorial 28. Finding Single-Quoted Strings, 410 -- Tutorial 29. Finding Currency Values, 411 -- Tutorial 30. Finding Time Values, 412 -- Tutorial 31. Recovering Text from Corrupted Documents, 413 -- Tutorial 32. Extracting Text from PDF Files, 415 -- Tutorial 33. Mail and HTTP Header Removal, 417 -- Tutorial 34. ISO 8601 Date Format Output, 419 -- Tutorial 35. Relative Date Tool (theDate), 421 -- Tutorial 36. ZIP/Postal Code-to-Location Mapping, 423 -- Tutorial 37. Shortest Distance Between Two Towns, 424 -- Tutorial 38. Dealing with Islands, 425 -- Tutorial 39. Calculate Centroid of Area, 427 -- Tutorial 40. Extracting Text from Illustrator, 428 -- Tutorial 41. Generating Candidate Keywords, 430 -- Tutorial 42. Extracting Metadata from Word Documents, 432 -- Tutorial 43. Extracting Metadata from Image Files, 433 -- Tutorial 44. Extract metadata from a QuickTime Movie, 434 -- Tutorial 45. Discovering Formats with File Magic, 437 -- Tutorial 46. Extracting Hyperlinks from Word Documents, 438 -- Tutorial 47. Extracting URLs from Raw Text, 439 -- Tutorial 48. Testing URL Hyperlinks, 440 -- Tutorial 49. Dictionary Lookups via Dict.org, 441 -- Tutorial 50. Lookup the Online Dictionary from a Web Page, 442 -- Tutorial 51. Check for Editorial Integrity, 443 -- Tutorial 52. Publish a Spreadsheet SYLK File, 444 -- Tutorial 53. Publish a Word RTF Document, 447 -- Tutorial 54. Publish an Adobe SVG, 452 -- Tutorial 55. Converting XML to HTML with XSLT, 454 -- Tutorial 56. Making Excel Spreadsheets with AppleScript, 456 -- Tutorial 57. Making Word Documents with AppleScript, 457 -- Tutorial 58. Scripting Alpha Channels in Photoshop, 458 -- Tutorial 59. Searching and Editing Word Docs, 459 -- Tutorial 60. Creating a Script Wrapper for Microsoft Word, 462 -- Tutorial 61. Putting It on the Desktop, 468 -- Tutorial 62. Remote Renderers and Compilers, 470 -- Appendix A. Data Exchange Containers, 473 -- Appendix B. Metadata Standards, 481 -- Appendix C. A Simple Metadata Dictionary, 495 -- Appendix D. Code Sets, 499 -- Appendix E. Regular Expressions 101, 503 -- Glossary, 507 -- Bibliography, 513 -- Webliography, 515 -- Index, 525 -- -- Chapter 1. Framing the Problem, 1 -- Chapter 2. Metadata, 11 -- Chapter 3. Object ModelingYour Data, 35 -- Chapter 4, Transfer and Conversion, 59 -- Clhapter 5. Dealing With Raw Data, 73 -- Chapter 6. Character Mapping and Code Sets, 81 -- Chapter 7. Data Fields, 93 -- Chapter 8. Fields, Records, and Tables, 97 -- Chapter 9. Times, Dates, Schedules, and Calendars, 107 -- Chapter 10. Names, Addresses, and Contacts, 127 -- Chapter 11 Spatial Data and Maps, 139 -- Chapter 12. Paint Me a Picture, 157 -- Chapter 13. Roll Tape!, 165 -- Chapter 14. Rights Issues, 185 -- Chapter 15. Integrating with Enterprise Systems, 191 -- Chapter 16. Data Exchange Formats, 197 -- Chapter 17. XML-Based Tools and Processes, 213 -- Chapter 18. Interfaces and APTs, 233 -- Chapter 19. Scripting Layers, 247 -- Chapter 20. U NIX Command Line Tools, 255 -- Chapter 21 Power Tools, 263 -- Chapter 22. Automation with Shell Scripts, 273 -- Chapter 23. Automation with AppleScript, 287 -- Chapter 24. Script Aui 'omaon in Windows, 287 -- Chapter 25. Compiled and Interpreted Languages, 299 -- Chapter 26. GUI Tools and Processes, 309 -- Chapter 27. Building Tools, 313 -- Chapter 28. Keep It Moving, 323 -- Chapter 29. Publishing Systems, 343 -- Chapter 30. Adding Intelligence and Metrics, 347 -- Chapter 31. Lateral Thinking, 353 -- Chapter 32. T7re Bottom Line, 359 -- Part 2. T utorials, 365 -- Tutorial 1. Calling Shell Commands from AppleScript, 369 -- ihtoria 2. Calling AppleScript from Shells, 370 -- Tutorial 3. Calling VisUal Basic from AppleScript, 372 -- Tutorial 4. CallingVisual Basic from UNIX, 373 -- Tuoriaal 5. Calling UNIX Shell Con Iands from C, 374 -- Tutorial 6. Calling ava from C Language, 375 -- Tutorial 7. Calli g C from Java, 376 -- futoria 8. Whal Your Web Server Log Can TellYou, 377 -- Tutorial 9. Monitoring Your Operating System Logs, 378 -- Tutorial 10. Mcasuring and Monitoring Disk Usage, 380 -- Tiutorial 11. Wrapping FTPTransfers in a Script, 385 -- Tutorial 12. Wrapping gip in a Shell Script, 389 -- Titoriat 13. Many-to-Many Relationships, 390 -- Tutorial 14. Phonetic Searches, 391 -- utorial 15. Fuzzy Searching and Sorting, 393 -- Tua orial 16. F nding Buffer Truncation Points, 394 -- utorial 17. Cl aning Unstructured Data, 395 -- Tiutorl I18. Sorting Out Address Data, 396 -- Tutorial 19. 'Time Data Cleaning, 400 -- Tutorial 20. Removing Duplicates, 401 -- Tutorial 21. Converting TSV to XML, 402 -- Tutorial 22. Removing Macros from Word Documents, 404 -- Tutorial 23. Removing all Hyperin ks from Word, 405 -- Tutorial 24. ecognizing U.S. ZIP Codes, 406 -- uhtorial 25. Recognizing UK Postal Codes, 407 -- Tutorial 26, Fining Variable Names in Source Codes, 408 -- Tutorial 27. Finding Doube-Quoted Strings, 409 -- Tuto rial 28. Finding Single-Quoted Strings, 410 -- Tutorial 29. Finding Currency Values, 411 -- utorial 30. Finding Time Values, 412 -- Tutorial 31. RecoveringTextfrom Corrupted Documents, 413 -- Tutorial 32. Extracting Textfirom PDF Files, 415 -- Tutorial 33. Mail and H7TP Header Removal, 4i 7 -- Tutorial 34. ISO 8601 Date -Forat Output, 419 -- Tuatorial 35. Relative Date Tool (theDate), 421 -- Tutorial 36. ZIP/Postal Code-to-Location Mapping, 423 -- "Tutoriai 37. Shortest Distance Betw een Two Towns, 424 -- Tutorial 38. Dealing with Islands, 425 -- Tutoria 39. Calculate Centroid of Area, 427 -- Tutorial 40. E1xtracting Textfrom llust rator 428 -- 'Tutorial 41. Generating Candidate Keywords, 430 -- Tutorial 42. Extracting Metadatafrom Word Documents, 432 -- Tutorial 43, Extracting Metadata from Image Files, 433 -- Tutorial 44. Extract Metadata from a QuickTime Movie, 434 -- utorial 45, Discovering Formats with File Magic, 437 -- 'Tutorial 46 Extracting Hyperlinks from Word Docum'ents, 438 -- titorial 47, E tracting URLs from Raw Text, 439 -- utonria 48, Testing URL Hyperlinks, 440 -- Tutorial 49, Dictionaly Lookups via Dict.org, 441 -- Tutorial 50. Lookup the Online Dictioniar from a Web Page, 442 -- Tutorial 51 Checkfor Editorial Integrity, 443 -- Tutorial 52. P blish a Spreadsheet SYLK File, 444 -- Tutoriai 53. Publish a Wod RT f Docuinet, 447 -- Tutoria 54. Publish an Adobe SVG, 452 -- Tuto riai 50. Converting ML to HTML wiit XSLT, 454 -- "Tutorial 56 Making Excel Spr adshet s with AppleScript, 456 -- T utorial 57 Making Word Doc anents with AppleScript, 457 -- Tutorial 58, Scripting Alpha Channels in Photoshop, 458 -- Tutorial 59. Searching and Editing Word Docs, 459 -- Tutorial 60. Creating a Script Wrapperfor Microsoft Word, 462 -- Tutorial 61, Putting It on the Desk top, 468 -- Tutorial 62. Remnote Renderers and Conmpilers, 470.