Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 611
  • Last Modified:

SED and AWK (gawk) field delimiters

Note: This code does work fine..  However, I am getting a tab (Chr(9)) between the fields and would like to get Chr(44) or a comma.. Is that possible under this construct or do I need to  re-format the file once generated?

sed -n "s/ns1://g;s/:ns1//g;/signin xmlns/,/signin/p;/\<signin.*/,/<\/signin>/{/\<orgName>/s/\<orgName><*/orgName>/};{/\<userName>/s/\<userName>[^m][^o][^n][^i][^t][^o][^r][^A][^c][^c][^t][^<]*/userName>/};{s/\<orgName>/<\/orgName>/}" "Apache_log" | gawk "/orgName/" { print substr($1,10,length($1)-19) }"|sort|uniq -c

Open in new window


Would also like to re-arrange the fields to be:
ORG,Time,Count

Currently, the raw logs are:
Count,ORG,Date,Time


Thanks,

Kent
0
Kent Dyer
Asked:
Kent Dyer
1 Solution
 
wesly_chenCommented:
To swap the count and content, just pipe to
...|sort| uniq -c| gwak '{print $2,$1}'
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now