The same data can be provided to you in many different ways. Below are four extracts of the same data. The first extract is properly formatted for import into the company database. Notice, that this extract uses a pipe delimiter, puts each unique record on a different row, and uses text qualifiers of a single quote when commas are present. Your task is to discuss how to transform the other extracts so they can be imported into the company database. Required For each of the other three data extracts, do the following: 1. Describe if delimiters are present, and if so, what they are. 2. Describe if text qualifiers are present, and if so, what they are. 3. Describe the steps you would take to prepare each extract for importing into the companys database.

Correct Format for Import PrimaryKey CustomerName CustomerAddress Description CreditLimit 1001 | Camp-a-lot Corporation 2103 County Rd W #W, Seymour, WI, 54165' Buys mostly in summer 10000 1002 Outdoors Forever Inc. '3145, Lake Geneva, WI, 53147 New customer 5080 1003A11Pro Camping|12303 233rd Ave, Trevor, WI, 53179 | Wants confirmations by telephone, email, and mail|'15,000 1994 Camping Extreme LLC'8153 W Holly Rd, Mequon, WI, 53097'||7000 1985 3D Camping Company 9624 N Lamplighter Ln, Thiensville, WI, 53092"Sells goods on consignment |'10,000 1. Extract 1 PrimaryKey, CustomerName, CustomerAddress, Description, CreditLimit 1001, Camp-a-lot Corporation, 2103 County Rd w #w, Seymour, WI, 54165, Buys mostly in summer, 10000 1002, Outdoors Forever Inc., 3145, Lake Geneva, WI, 53147, New customer, 5000 1893, A11Pro Camping, '12303 233rd Ave, Trevor, WI, 53179, Wants confirmations by telephone, email, and mail, 15,800 1004, Camping Extreme LLC, 8153 W Holly Rd, Mequon, WI, 53097,,7080 1095,3D Camping Company, 9624 N Lamplighter Ln, Thiensville, WI, 53092, Sells goods on consignment, 18,000 2. Extract 2 PrimaryKeyCustomerName Customer Address Description CreditLimit 1001Camp-a-lot Corporation "2103 County Rd W #W, Seymour, WI, 54165" Buys mostly in summer 10000 10020utdoors Forever Inc. "3145, Lake Geneva, WI, 53147" New customer 5000 1003AllPro Camping "12303 233rd Ave, Trevor, WI, 53179" Wants confirmations by telephone, email, and mail 1004Camping Extreme LLC "8153 W Holly Rd, Mequon, WI, 53097" 7800 1805JD Camping Company *9624 N Lamplighter Ln, Thiensville, WI, 53092" Sells goods on consignment 10,000 15,000 3. Extract 3 Primarykey CustomerName CustomerAddress Description CreditLimit 1001 Camp-a-lot Corporation '2103 County Rd W #W, Seymour, WI, 54165 Buys mostly in summer | 10908 1002 Outdoors Forever Inc. 3145, Lake Geneva, WI, 53147' New customer 5000 1003 AllPro Camping '12303 233rd Ave, Trevor, WI, 53179 Wants confirmations by telephone, email, and maill'15,000' 1084 Camping Extreme LLC 8153 W Holly Rd, Mequon, WI, 53097' || 7000 1005 JD Camping Company 9624 N Lamplighter Ln, Thiensville, WI, 53092 Sells goods on consignment |'10,000' Correct Format for Import PrimaryKey CustomerName CustomerAddress Description CreditLimit 1001 | Camp-a-lot Corporation 2103 County Rd W #W, Seymour, WI, 54165' Buys mostly in summer 10000 1002 Outdoors Forever Inc. '3145, Lake Geneva, WI, 53147 New customer 5080 1003A11Pro Camping|12303 233rd Ave, Trevor, WI, 53179 | Wants confirmations by telephone, email, and mail|'15,000 1994 Camping Extreme LLC'8153 W Holly Rd, Mequon, WI, 53097'||7000 1985 3D Camping Company 9624 N Lamplighter Ln, Thiensville, WI, 53092"Sells goods on consignment |'10,000 1. Extract 1 PrimaryKey, CustomerName, CustomerAddress, Description, CreditLimit 1001, Camp-a-lot Corporation, 2103 County Rd w #w, Seymour, WI, 54165, Buys mostly in summer, 10000 1002, Outdoors Forever Inc., 3145, Lake Geneva, WI, 53147, New customer, 5000 1893, A11Pro Camping, '12303 233rd Ave, Trevor, WI, 53179, Wants confirmations by telephone, email, and mail, 15,800 1004, Camping Extreme LLC, 8153 W Holly Rd, Mequon, WI, 53097,,7080 1095,3D Camping Company, 9624 N Lamplighter Ln, Thiensville, WI, 53092, Sells goods on consignment, 18,000 2. Extract 2 PrimaryKeyCustomerName Customer Address Description CreditLimit 1001Camp-a-lot Corporation "2103 County Rd W #W, Seymour, WI, 54165" Buys mostly in summer 10000 10020utdoors Forever Inc. "3145, Lake Geneva, WI, 53147" New customer 5000 1003AllPro Camping "12303 233rd Ave, Trevor, WI, 53179" Wants confirmations by telephone, email, and mail 1004Camping Extreme LLC "8153 W Holly Rd, Mequon, WI, 53097" 7800 1805JD Camping Company *9624 N Lamplighter Ln, Thiensville, WI, 53092" Sells goods on consignment 10,000 15,000 3. Extract 3 Primarykey CustomerName CustomerAddress Description CreditLimit 1001 Camp-a-lot Corporation '2103 County Rd W #W, Seymour, WI, 54165 Buys mostly in summer | 10908 1002 Outdoors Forever Inc. 3145, Lake Geneva, WI, 53147' New customer 5000 1003 AllPro Camping '12303 233rd Ave, Trevor, WI, 53179 Wants confirmations by telephone, email, and maill'15,000' 1084 Camping Extreme LLC 8153 W Holly Rd, Mequon, WI, 53097' || 7000 1005 JD Camping Company 9624 N Lamplighter Ln, Thiensville, WI, 53092 Sells goods on consignment |'10,000