Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk - How to preserve whitespace?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk - How to preserve whitespace?
# 8  
Old 02-06-2013
Quote:
Originally Posted by rdrtx1
try also:
Code:
awk '
BEGIN {c[3]=13; c[4]="*"; c[5]="$W1"}
$0 ~ /^\// {
   l=$0; o="";
   for (i=1; i<=NF; i++) {
     w=l; sub("[ \t].*", "", w);
     o=o (c[i] ? c[i] : w);
     sub("^[ \t]*", "", l);
     sub("^[^ \t]*" , "", l);
     w=l; sub("[^ \t].*", "", w);
     o=o w; sub("^[ \t]*", "", l);
   }
   $0=o;
} 1
' newsyslog.conf

This looks like it'll work!

The output is just a little "off", but I believe it'll work. Just in case there's a reasonable way to make the columns a little more aesthetic...

Code:
/var/log/appfirewall.log		640  13     *	$W1     J
/var/log/ftp.log			640  13	   *	$W1     J
/var/log/hwmond.log			640  13	   *	$W1     J
/var/log/install.log			640  13	   *	$W1     J
/var/log/ipfw.log			640  13	   *	$W1     J
/var/log/lookupd.log			640  13	   *	$W1     J
/var/log/lpr.log			640  13	   *	$W1     J
/var/log/mail.log			640  13	   *	$W1     J
/var/log/ppp.log			640  13	   *	$W1     J
/var/log/secure.log			640  13	   *	$W1     J
/var/log/system.log			640  13	   *	$W1  J
/var/log/wtmp				644  13	   *	$W1 B

# 9  
Old 02-06-2013
This seems to come close to what you're expecting (without needing GNU awk >= 4):
Code:
awk '
/^\// { $3 = 13
        $4 = "*"
        $5 = "$W1"
        printf("%s", $1)
        for(w = length($1); w < 40; w += 8) printf("\t")
        printf("%-5d%-2d\t   %s\t%-6s%s\n", $2, $3, $4, $5, $6)
        next
}
1' input

If you're using a Solaris/SunOS system, use /usr/xpg4/bin/awk or nawk instead of awk.
It produces:
Code:
... ... ...
# contents of maillog, messages, and lpd-errs to be confidential.  In the
# future, these defaults may change to more conservative ones.
#
# logfilename          [owner:group]    mode count size when  flags [/pid_file] [sig_num]
/var/log/appfirewall.log		640  13	   *	$W1   J
/var/log/ftp.log			640  13	   *	$W1   J
/var/log/hwmond.log			640  13	   *	$W1   J
/var/log/install.log			640  13	   *	$W1   J
/var/log/ipfw.log			640  13	   *	$W1   J
/var/log/lookupd.log			640  13	   *	$W1   J
/var/log/lpr.log			640  13	   *	$W1   J
/var/log/mail.log			640  13	   *	$W1   J
/var/log/ppp.log			640  13	   *	$W1   J
/var/log/secure.log			640  13	   *	$W1   J
/var/log/system.log			640  13	   *	$W1   J
/var/log/wtmp				644  13	   *	$W1   B

except that the copy and paste used to produce this converts the tabs in the output to spaces.
Last edited by Don Cragun; 02-06-2013 at 07:37 PM.. Reason: add sample output
# 10  
Old 02-06-2013
I copied and pasted from the first example output and from the last output posted and the spacing looks fine.

try adding | expand after input file. This will fill in the white space.
# 11  
Old 02-06-2013
Try this one as well:

Code:
awk '
function rep(a,v) {
  sub("^(([^ \t]+[ \t]+){"a-1"})","&" SUBSEP);
  sub(SUBSEP "[^ \t]+", v);
}   
/^\// {
    rep(3,"13")
    rep(4,"*")
    rep(5,"$W1")
} 1' newsyslog.conf
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed to repeat every character on same position from the upper line replacing whitespace

Hello is it possible with awk or sed to replace any white space with the previous line characters in the same position? I am asking this because the file I have doesn't always follow a pattern. For example the file I have is the result of a command to obtain windows ACLs: icacls C:\ /t... (5 Replies)
Discussion started by: nakaedu
5 Replies

2. Shell Programming and Scripting

awk to ignore whitespace in field

The awk below executes and update the desired field in my first awk. However, the white space between nonsynonymous SNV in $9 is being split into tabs and my attempt to correct this does not update the field unless it is removed. I am not sure what I am doing wrong? Thank you :). file1 ... (4 Replies)
Discussion started by: cmccabe
4 Replies

3. Shell Programming and Scripting

Awk: Dealing with whitespace in associative array indicies

Is there a reliable way to deal with whitespace in array indicies? I am trying to annotate fails in a database using a table of known fails. In a begin block I have code like this: # Read in Known Fail List getline < "'"$failListFile"'"; getline < "'"$failListFile"'"; getline <... (6 Replies)
Discussion started by: Michael Stora
6 Replies

4. Shell Programming and Scripting

How to preserve spaces in input fields with awk?

I'm trying to do something pretty simple but its appears more complicated than expected... I've lines in a text file, separated by the comma and that I want to output to another file, without the first field. Input file: file1,item, 12345678 file2,item, 12345678 file2,item, ... (8 Replies)
Discussion started by: Armoric
8 Replies

5. UNIX for Dummies Questions & Answers

[Solved] How remove leading whitespace from xml (sed /awk?)

Hi again I have an xml file and want to remove the leading white space as it causes me issues later in my script I see sed is possible but cant seem to get it to work I tried sed 's/^ *//' file.xml output <xn:VsDataContainer id="1U104799" modifier="update"> ... (10 Replies)
Discussion started by: aniquebmx
10 Replies

6. Shell Programming and Scripting

Preserve trailing whitespace in variable

Hello, I wondering how I can echo a string without having the trailing whitespace removed. For example I have a string str="TESTING123 " that I need to hash using sha1. I get the correct answer when I run the line below from the terminal $ echo -n "TESTING123 " | openssl sha1... (3 Replies)
Discussion started by: colinireland
3 Replies

7. Shell Programming and Scripting

Date Format - preserve whitespace

I am trying to change the date format for the following: YESTER=`TZ=aaa24 date +%b" "%d | sed 's/0/ /'` TraceList=$(ls -ltR /pdt/logs | grep "$YESTER" | awk '{print $9}') CMD2=$(find /disk/dan/dansFiles/pass/logs/$TList -name cmd\* -prune) what I am trying to do in the above... (1 Reply)
Discussion started by: ther2000
1 Replies

8. Shell Programming and Scripting

Preserve space in variable of AWK

This seems to be a stupid basic question, but I cant get the space to stick in the awk variable. I do use this command to grep a time range of the log file. cat /var/log/daemon.log | awk '$0>=from&&$0<=to' from="$(date +%b" "%e" "%H:%M:%S -d -24hour)" to="$(date +%b" "%e" "%H:%M:%S)" I now... (9 Replies)
Discussion started by: Jotne
9 Replies

9. Shell Programming and Scripting

How to match (whitespace digits whitespace) sequence?

Hi Following is an example line. echo "192.22.22.22 \"33dffwef\" 200 300 dsdsd" | sed "s:\(\ *\ \):\1:" I want it's output to be 200 However this is not the case. Can you tell me how to do it? I don't want to use AWK for this. Secondly, how can i fetch just 300? Should I use "\2"... (3 Replies)
Discussion started by: shahanali
3 Replies

10. Shell Programming and Scripting

Unable to assign value to variable using awk coz of whitespace in value

Unix gurus, I have a file as below, which is basically the result set obtained from a sql query on an Oracle database. ID PROG_NAME USER_PROG_NAME -------- --------------- ---------------------------------------- 33045 INCOIN Import Items 42690 ... (3 Replies)
Discussion started by: sunpraveen
3 Replies
Login or Register to Ask a Question