CR LF and CRLF in flat files

When we are working with the Flat files or CSV file or Fixed width flat files we are here these words CR, LF, and CRLF.

Different the operating system has the different way of representing the new line.

MAC OS understands \r as newline (CL).

UNIX or Linux Operating System understands the \n as newline (LF).

Window The operating system understands the \r\n as newline (CRLF).

Due to this reason file is created on one system (OS) may not support in another OS.

SQL code for this

CR ASCII Code 13 CHAR (13)

LF ASCII Code 10 CHAR (10)