Using multiple delimiters in awk

Question

I have a file which contain following lines    logs tc0001 tomcat tomcat7 1 conf catalina properties app env server name   demo example com  logs tc0001 tomcat tomcat7 2 conf catalina properties app env server name   quest example com  logs tc0001 tomcat tomcat7 5 conf catalina properties app env server name   www example com   In above output I want to extract 3 fields  Number 2  4 and the last one   example com   I am getting the following output   cat file   awk -F      print  3   t   5   tc0001   tomcat7 1 tc0001   tomcat7 2 tc0001   tomcat7 5   How do I also extract last field with domain name which is after      How do I use multiple delimiter to extract field

User · Answer

Perl one-liner   perl -F          -lane  print   F 2  t F 4  t F 7    file   These command-line options are used    -n loop around every line of the input file  put the line in the    variable  do not automatically print every line -l removes newlines before processing  and adds them back in afterwards -a autosplit mode     perl will automatically split input lines into the  F array   Defaults to splitting on whitespace -F autosplit modifier  in this example splits on either   or   -e execute the perl code   Perl is closely related to awk  however  the  F autosplit array starts at index  F 0  while awk fields start with  1

User · Answer

The delimiter can be a regular expression   awk -F         print  3   t   5   t   8   file   Produces   tc0001   tomcat7 1    demo example com   tc0001   tomcat7 2    quest example com   tc0001   tomcat7 5    www example com

User · Answer

Good news  awk field separator can be a regular expression  You just need to use -F  lt separator1 gt   lt separator2 gt         awk -F      -vOFS   t    print  3   5   NF   file   Returns   tc0001  tomcat7 1  demo example com tc0001  tomcat7 2  quest example com tc0001  tomcat7 5  www example com   Here    -F      sets the input field separator to either   or    Then  it sets the output field separator to a tab  -vOFS   t  is using the -v flag for setting a variable  OFS is the default variable for the Output Field Separator and it is set to the tab character  The flag is necessary because there is no built-in for the OFS like -F   print  3   5   NF  prints the 3rd  5th and last fields based on the input field separator      See another example     cat file hello how are you i am very well thank you   This file has two fields separators    and    If we want to print the second field regardless of the separator being one or the other  let s make both be separators     awk -F        print  2   file how am   Where the files are numbered as follows   hello how are you           i am very well thank you                                                        1    2   3   4            1  2   3    4    5    6

User · Answer

For a field separator of any number 2 through 5 or letter a or   or a space  where the separating character must be repeated at least 2 times and not more than 6 times  for example   awk -F  2-5a    2 6         I am sure variations of this exist using     and parameters

User · Answer

Another one is to use the -F option but pass it regex to print the text between left and or right parenthesis      The file content   528 smbw  529 smbt  530 smbn  10115 smbs    The command   awk -F         print  2   filename   result   smbw smbt smbn smbs   Using awk to just print the text between      Use awk -F        but  awk -F       will not work   http   stanlo45 blogspot com 2020 06 awk-multiple-field-separators html

User · Answer

If your whitespace is consistent you could use that as a delimiter  also instead of inserting  t directly  you could set the output separator and it will be included automatically    lt  file awk -v OFS   t  -v FS          print  3   5   NF

User · Answer

I see many perfect answers are up on the board  but still would like to upload my piece of code too   awk -F      print  3         5          7   sam   sed  s  cat      g

[awk] Using multiple delimiters in awk

Examples related to awk

Examples related to command-line

Examples related to text-processing