Summary

This chapter provided a variety of parsing methods that will help you parse out data in no time. With the Text to Columns tool, you learned about splitting the data from one field into columns or rows. This is a great way to identify segments of the data for analysis. The DateTime tool was a real force in converting date/time formats to string formats, and vice versa converting string formats to date/time formats. This tool is very handy if dates and times need to be cleaned up quickly. If you're looking for more robust parsing, then the RegEx tool is where a variety of regular expressions can be applied and the Match output method was the desired output. The tools and methods applied in this chapter will provide you with a foundation for parsing data with a variety of specifications.

In the next chapter, you will learn about the reporting tools and how to implement them in your workflow to create custom data-driven reports.