Linux sed and awk Cheat Sheet/Use a custom field separator

Split CSV-like data on commas.

Section: awk Fields and Records

Use a custom field separator

bash
bash
awk -F, '{print $1, $2}' users.csv
Explanation

`-F` sets the input field separator.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing awk Fields and Records
Print selected columns
Show the first and third whitespace-delimited fields.
OpenIn sheetbashsame section
Print the last field
Use NF to reference the final field on each line.
OpenIn sheetbashsame section
Print line numbers with lines
Prefix each line with NR.
OpenIn sheetbashsame section
Set output field separator
Join output fields with commas.
OpenIn sheetbashsame section
Skip a header row
Ignore the first line of a delimited file.
OpenIn sheetbash2 tag match
Print rows matching a condition
Show lines where column 3 is greater than 100.
OpenIn sheetbash1 tag match