\u00a0 \u00a0X1 X2 X3 X4 X5
\nY1 3000 5000 745 122 875
\nY2 942 400 263 558 991
\nY3 325 584 775 381 545
\nY4 654 336 272 883 235
\nY5 241 154 782 754 899<\/code><\/p>\nNotice that the column headers do not always line up with the rest of the columns; this is nothing to worry about. If you have a file like this (or are creating one), it is helpful to have a blank new line at the end (i.e., a blank extra row). This can help with the display and processing of text files.<\/p>\n
Say you want to display the contents of the text file. Any easy way to do this is with cat {file}.txt<\/code>. This will quickly display the contents on the screen. If it’s a long text file, you should use less {file}.txt<\/code> instead of cat<\/code>.<\/p>\nHere’s what this looks like with our sample file.<\/p>\n
![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/cat_screenshot_bash-300x249.png\" "\\"cat_screenshot_bash\\"")
<\/a>If you want to number the lines, you can run cat -n {file}.txt<\/code>, which results in a display like this:<\/p>\n![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/cat_bash_numbered-300x249.png\" "\\"cat_bash_numbered\\"")
<\/a>Or, you can use awk:\u00a0awk 'FNR==1{print \"\"}1' {file}.txt<\/code><\/p>\n![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/awk_cat_bash-300x249.png\" "\\"awk_cat_bash\\"")
<\/a>Now, let’s say that instead of the entire file, you just want a row of values or a single value. Here’s a way to display just one row: awk 'BEGIN { RS = \"\" ; FS = \"\\n\" } ; { print $2 }' {file}.txt<\/code><\/p>\nThe {print $2}<\/code> specifies the second row in the file. This could be changed to $3, $5, $8, or whatever you want, if it’s a valid row number in the file.<\/p>\n![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/awk_single_row-300x249.png\" "\\"awk_single_row\\"")
<\/a>You could also write that line to a new file with ><\/code> or the pipe |.<\/code><\/p>\nNow, what if you want a column from the file?<\/p>\n
awk '{ print $3 }' {file}.txt<\/code><\/p>\n![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/awk_print_column-300x249.png\" "\\"awk_print_column\\"")
<\/a>Now, what if you want only a single value from the text file. I know there are shorter ways of doing this but one way is to do a two-step awk command by combining the column and row commands I already demonstrated:
\n<\/code><\/p>\nawk 'BEGIN { RS = \"\" ; FS = \"\\n\" } ; { print $2 }' {file}.txt | tee -a file_tmp.txt;
\nawk '{ print $3; exit }' file_tmp.txt | tee -a subject_volume.txt;
\nrm file_tmp.txt<\/code><\/p>\n![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/awk_column_row_value-300x249.png\" "\\"awk_column_row_value\\"")
<\/a><\/p>\nThis displays the second row in the file and writes it to a temporary file; then it reads and displays and saves the value from the 3rd column in the temp file. The “exit” part of the second command will limit the print command to a single value, should there be multiple values in the column (or row). Lastly, it deletes the temp file. In the screenshot above, I am showing the value in the second row, third column (this includes the row and coumn labels). You could also run this with the column command first, if that’s easier.<\/p>\n
This can save you a lot of time if you have to pull out values from a lot of text files (e.g., aseg.stats) by using a for or while loop. I recently did this to pull values out of some text files. It would have taken hours to pull out the correct values from every participant by hand. With a script (series of “for” loops) it ran in seconds. Then, I had a file with all the values for all the participants, which was then imported into Excel.<\/p>\n
I am a novice user of awk so specific questions about it are best directed elsewhere. This is just what I’ve figured out by reading various guides online.<\/p>\n","protected":false},"excerpt":{"rendered":"
With neuroimaging analyses we deal with a lot of text files. These are often the result of program or scripts running on the MRI data; they can be statistics, volumes, error logs, or any number of other outputs. Let’s say … Continue reading
![\"\"](\"http:\/\/brainybehavior.com\/neuroimaging\/wp-content\/uploads\/2011\/11\/cat_screenshot_bash.png\" "\\"cat_screenshot_bash\\"")
<\/a>If you want to number the lines, you can run