Question

For the following data, identify what are the text qualifiers and delimiters. If a text qualifier or delimiter is not used, answer "none."

Flat file, Header Row:

DocumentNum;BankName BankAddress;DocumentDescription

Flat File Data Row:

331-12;"First Bank" "429 Taylor St. Haines City, FL 33844";"Loan Agreement"

Answer 1

A text qualifier is a symbol that let's Excel know where text begins and ends. It is used specifically when importing data.

i.e.. started with header name with data row as same details likee documentNum; and 331-12

and end with DocumentDescription and "Loan Agreement"

A delimiter is one or more characters that separate text strings. Common delimiters are commas (,), semicolon (;), quotes ( ", ' ), braces ({}), pipes (|), or slashes ( / \ ). When a program stores sequential or tabular data, it delimits each item of data with a predefined character.