tags:

views:

79

answers:

1
Q: 

awk help for getting fields

I have field like 

a_b_c_d

I want as the output a b c_d, this query wont work for this 

awk -F"_" <file> | '{print $1,$2,$3}'

Since it will only print a b c

+4  A: 

Try

awk -F"_" -f <file> '{ print $1" "$2" "$3"_"$4 }'

In other words,

$echo a_b_c_d | awk -F"_" '{ print $1" "$2" "$3"_"$4 }'      
a b c_d

The code in the brackets means

  • print the first match
  • print space
  • print the second match
  • print space
  • ...
Masi  2009-07-02 21:31:26
Minor detail, but you can just do `awk -F_` instead of `awk -F"_"`.
Mark Rushakoff  2009-07-02 22:52:23
yes, the simplest solution is to print the _ implicitly.
dalloliogm  2009-07-27 12:31:17

related questions

Keeping original format POST passing through AWK
[bash] Fill placeholders in file in single pass
Awk question: combining fields
What are the differences between Perl, Python, AWK and sed?
How to write a unix filter that outputs only a line every N lines
Shell script numbering lines in a file
Awk matching of entire record using regular expression
How to print the Nth column of a text file with AWK using argv
parse csv file using gawk
In sed or awk, how do I handle record separators which *may* span multiple lines?
How can I append the name of a file to end of each line in that file?
AWK: redirecting script output from script to another file with dynamic name
concatenating many email files with unix utils
How can I extract lines of text from a file?
How do you split a file base on a token?
Best Awk Commands
Regex in awk and WinGrep
Can awk skip files which do not exist, race-free?
How do I print a field from a pipe-separated file?
Awk scripting help - Logic Issue
Searching/reading another file from awk based on current file's contents, is it possible?
Is there still any reason to learn AWK ?
sorting hashes/arrays in awk
Is there a Unix utility to prepend timestamps to lines of text?
Faster way to find duplicates conditioned by time