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:• Describe if delimiters are present, and if so, what they are.• Describe if text qualifiers are present, and if so, what they are.• Describe the steps you would take to prepare each extract for importing into the company’s database.

Transcribed Image Text:

PrimaryKey CustomerName Customer Address Description CreditLimit 1001 | Camp-a-lot Corporation | 2103 County Rd W #VV, Seymour, WI, 54165 Buys mostly in summer | 10000 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 mail| '15,000' 1004 Camping Extreme LLC '8153 W Holly Rd, Mequon, WI, 53097* ||7000 1005 3D Camping Company | 9624 N Lamplighter Ln, Thiensville, WI, 53092 |Sells goods on consignment | '10,000' 1. Extract 1 PrimaryKey, CustomerName, Customer Address, Description, CreditLimit 1001, Camp-a-lot Corporation, 2103 County Rd W #VV, Seymour, WI, 54165, Buys mostly in summer, 10000 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 mail,15,000 1004, 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 2. Extract 2 PrimaryKeyCustomerName Customer Address Description 1001Camp-a-lot Corporation 10020utdoors Forever Inc. Credit Limit Buys mostly in summer 10000 "2103 County Rd W #VV, Seymour, WI, 54165" "3145, Lake Geneva, WI, 53147" New customer 5000 Wants confirmations by telephone, email, and mail 7000 10,000 1003A11Pro Camping "12303 233rd Ave, Trevor, WI, 53179" 1004Camping Extreme LLC "8153 W Holly Rd, Mequon, WI, 53097" 1805JD Camping Company "9624 N Lamplighter Ln, Thiensville, WI, 53092" Sells goods on consignment 15,000