chapter_10.xlsx
Bond - Student
| Data | Agent | Commodity | Amount |
| 1/2/14 | Hannah | Bond | $1,000 |
| 1/22/14 | Hannah | Bond | $350 |
| 2/4/14 | Lindemann | Bond | $150 |
| 2/28/14 | Lindemann | Bond | $110 |
| 3/6/14 | Lindemann | Bond | $1,200 |
| 3/24/14 | McKenner | Bond | $1,500 |
| 4/1/14 | McKenner | Bond | $750 |
| 4/30/14 | Noel | Bond | $500 |
| 5/5/14 | Noel | Bond | $425 |
| 5/31/14 | Noel | Bond | $2,000 |
| 6/4/14 | Fox | Bond | $250 |
| 6/18/14 | Fox | Bond | $800 |
| 7/19/14 | Fox | Bond | $110 |
| 8/9/14 | Fox | Bond | $650 |
Import a Text File
| Broker_ID | Name | Address | City | State |
| 1980 | Ryan Miller | 412 Highland Ave | Dallas | TX 75205 |
| 4685 | Carrie Folkerts | 749 Abby Drive | Anchorage | AK 84965 |
| 2864 | Sara Zellon | 3412 Broadway | Nashville | TN 37204 |
| 8391 | Les Flint | 647 Bluemont Court | Chicago | IL 60478 |
| 5163 | Charlene Rush | Moana Blvde | Honolulu | HI 96850 |
Text to Columns
| Broker_ID | First Name | Last Name | Address | City | State | Zip Code |
| 1980 | Ryan | Miller | 412 Highland Ave | Dallas | TX | 75205 |
| 4685 | Carrie | Folkerts | 749 Abby Drive | Anchorage | AK | 84965 |
| 2864 | Sara | Zellon | 3412 Broadway | Nashville | TN | 37204 |
| 8391 | Les | Flint | 647 Bluemont Court | Chicago | IL | 60478 |
| 5163 | Charlene | Rush | Moana Blvde | Honolulu | HI | 96850 |
Import XML Data
| Type | Age | Sex | Name | Color | DateIn | DateAdopted |
| Cat | 3 years | Male | Paws | White | 3/15/2016 |
| Cat | 8 years | Female | Mama Mia | Calico | 2/15/2016 | 3/21/2016 |
| Dog | 2 years | Female | Mrs. Wolf | Brown | 3/8/2016 |
| Cat | 4 months | Male | Twerpy | | 3/12/2016 | 3/13/2016 |
| Dog | 7 months | Female | Betsy | Black and White | 2/25/2016 | 3/14/2016 |
| Dog | | Male | Fido | Brown and White | 3/17/2016 |
| Cat | 11 months | Female | Misty | Black | 3/10/2016 |
| Cat | 5 years | Male | Jasper | Black | 1/31/2016 |
| Cat | 12 years | Female | Grumpy | Gray | 2/1/2016 | 3/18/2016 |
TTT12
