DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Dash
|
|
|
Character Space
|
|
|
Division
|
|
|
Delimiter
|
Detailed explanation-1: -Delimited text files (.txt), in which the TAB character (ASCII character code 009) typically separates each field of text.
Detailed explanation-2: -Data in a delimited text file is arranged in rows and columns, with one entry per row. Each column is separated from the next by a field separator character.
Detailed explanation-3: -DELIMITER= or SEPARATOR= data field delimiters = “ “, fixed fields. To do this, specify the following command DELIMITER= value (or SEPARATOR= value). This value is the separator. DELIMITER="; ” semi-colon separated values.
Detailed explanation-4: -To summarize, a delimiter in CSV is a character (comma or another) that separates the data in your file into separate values.
Detailed explanation-5: -You can split the data by using a common delimiter character. A delimiter character is usually a comma, tab, space, or semi-colon. This character separates each chunk of data within the text string.