# xan rename ```txt Rename columns of a CSV file. Can also be used to add headers to a headless CSV file. The new names must be passed in CSV format to the column as argument, which can be useful if the desired column names contains actual commas and/or double quotes. Note that to be as performant as possible, this command does not try to be clever and only parses the first CSV row to drop it. The rest of the file will be flushed to the output as-is without any kind of normalization. Renaming all columns: $ xan rename NAME,SURNAME,AGE file.csv Renaming a selection of columns: $ xan rename NAME,SURNAME -s name,surname file.csv $ xan rename NAME,SURNAME -s '0-1' file.csv Adding a header to a headless file: $ xan rename -n name,surname file.csv Prefixing column names: $ xan rename --prefix university_ file.csv Column names with characters that need escaping: $ xan rename 'NAME OF PERSON,"AGE, ""OF"" PERSON"' file.csv Usage: xan rename [options] --replace [] xan rename [options] --prefix [] xan rename [options] --suffix [] xan rename [options] --slugify [] xan rename [options] [] xan rename --help rename options: -s, --select Select the columns to rename. See 'xan select -h' for the full syntax. Note that given selection must not include a same column more than once. -p, --prefix Prefix to add to all column names. -x, --suffix Suffix to add to all column names. -S, --slugify Transform the column name so that they are safe to be used as identifiers. Will typically replace whitespace & dashes with underscores, drop accentuation etc. -R, --replace Replace matches of a pattern by given replacement in column names. -f, --force Ignore unknown columns to be renamed. Common options: -h, --help Display this message -o, --output Write output to instead of stdout. -n, --no-headers When set, the first row will not be interpreted as headers. (i.e., They are not searched, analyzed, sliced, etc.) -d, --delimiter The field delimiter for reading CSV data. Must be a single character. ```