# xan flatten ```txt Prints flattened records such that fields are labeled separated by a new line. This mode is particularly useful for viewing one record at a time. There is also a condensed view (-c or --condense) that will shorten the contents of each field to provide a summary view. Pipe into "less -r" if you need to page the result, and use --color=always not to lose the colors: $ xan flatten --color=always file.csv | less -Sr Usage: xan flatten [options] [] xan f [options] [] flatten options: -s, --select Select the columns to visualize. See 'xan select -h' for the full syntax. -l, --limit Maximum number of rows to read. Defaults to read the whole file. -c, --condense Don't wrap cell values on new lines but truncate them with ellipsis instead. -w, --wrap Wrap cell values all while minding the header's indent. -F, --flatter Even flatter representation alternating column name and content on different lines in the output. Useful to display cells containing large chunks of text. --row-separator Separate rows in the output with the given string, instead of displaying a header with row index. If an empty string is given, e.g. --row-separator '', will not separate rows at all. --csv Write the result as a CSV file with the row,field,value columns instead. Can be seen as unpivoting the whole file. --cols Width of the graph in terminal columns, i.e. characters. Defaults to using all your terminal's width or 80 if terminal's size cannot be found (i.e. when piping to file). Can also be given as a ratio of the terminal's width e.g. "0.5". -R, --rainbow Alternating colors for cells, rather than color by value type. --color When to color the output using ANSI escape codes. Use `auto` for automatic detection, `never` to disable colors completely and `always` to force colors, even when the output could not handle them. [default: auto] -S, --split Split columns containing multiple values separated by --sep to be displayed as a list. --sep Delimiter separating multiple values in cells split by --plural. [default: |] -H, --highlight Highlight in red parts of text cells matching given regex pattern. Will not work with -R/--rainbow. -i, --ignore-case If given, pattern given to -H/--highlight will be case-insensitive. Common options: -h, --help Display this message -o, --output Write output to instead of stdout. Only used when --csv is set. -n, --no-headers When set, the first row will not be interpreted as headers. When set, the name of each field will be its index. -d, --delimiter The field delimiter for reading CSV data. Must be a single character. ```