Answer

Given the following input and output, what was used as the delimiter in the Text to Columns tool? Input: Record Number Vehicles 1 1 Cars,|-Black;NH, White-CT 2 2 Trucks|,Gray-MA;NH|White--CT 3 3 Vans--,|Black, NH|White,CT; Output: Record Number Vehicles Vehicles1 Vehicles2 Vehicles3 1 Cars,|-Black;NH,,White-CT Cars,| Black;NH,White CT 2 2 Trucks|,Gray-MA;NH|White--CT Trucks|,Gray MANH|White -CT 3 3 Vans--,|Black, NH|White,CT; Vans [Black, NH|White,CT; A. B. B O c. O D. ;

Transcribed Image Text:

Given the following input and output, what was used as the delimiter in the Text to Columns tool? FB Input: Record Number 1 1 2 2 33 Vehicles Cars, -Black NH,,White-CT Trucks Gray-MA;NH|White--CT Vans--|Black,NH|White, CT; Output: Record Number Vehicles Vehicles1 Vehicles2 Vehicles3 1 1 Cars,|-Black;NH,White-CT Cars, Black NH, White CT 22 Trucks,Gray-MA:NH|White--CT Trucks,Gray MA;NH|White -CT 3 3 Vans--, Black,NH|White, CT; Vans Black NH|White, CT; A. B. B C. D.. Given the following input and output, what was used as the delimiter in the Text to Columns tool? FB Input: Record Number 1 1 2 2 33 Vehicles Cars, -Black NH,,White-CT Trucks Gray-MA;NH|White--CT Vans--|Black,NH|White, CT; Output: Record Number Vehicles Vehicles1 Vehicles2 Vehicles3 1 1 Cars,|-Black;NH,White-CT Cars, Black NH, White CT 22 Trucks,Gray-MA:NH|White--CT Trucks,Gray MA;NH|White -CT 3 3 Vans--, Black,NH|White, CT; Vans Black NH|White, CT; A. B. B C. D..