Sponsored Content
Full Discussion: awk Print help
Top Forums Shell Programming and Scripting awk Print help Post 302956721 by ahmed.vaghar on Friday 2nd of October 2015 10:22:24 AM
Old 10-02-2015
Rudy,

Thank you very much it helped.Can you please help me how to write this into a CSV or XLS file.

I tried this it is writing everything in one column.

Code:
last -w -F | tac | awk -vOFS=";" 'BEGIN   {print "USERNAME;HOSTNAME;LOGIN_TIME;LOGOUT_TIME;DURATION"}{print $1, $3, $5$6$7$8, $11$12$13$14, $15}' > /home/avaghar/Output.csv

USERNAME;HOSTNAME;LOGIN_TIME;LOGOUT_TIME;DURATION
wtmp;Tue;1915:49:472015;;
;;;;
reboot;boot;TueMay1915:50:13;TueMay1915:52:13;2015
root;:0;May1915:50:372015;May1915:51:152015;(00:00)
root;:0.0;May1915:50:462015;May1915:50:512015;(00:00)


Can you please help me how to split this and write data in each column.

Thanks,

Last edited by Don Cragun; 10-02-2015 at 05:22 PM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk print $2

/oracle/ID1/saparch"|awk '{print $2}' what does print $2 means? (1 Reply)
Discussion started by: yls177
1 Replies

2. Shell Programming and Scripting

How do I get awk to print a " in it's print part?

The line is simple, use " '{ print $1"]"$2"\"$3THE " NEEDS TO GO HERE$4 }' I've tried \", "\, ^" and '"" but none of it works. What am I missing? Putting in the [ between $1 and $2 works fine, I just need to do the same with a ". Thanks. (2 Replies)
Discussion started by: LordJezo
2 Replies

3. Shell Programming and Scripting

Awk and print help

Hello I have a log file like so 2009-01-15 17:55:06 H=host-216-153-217-114.spr.choiceone.net :30675 I=:25 F=<> rejected RCPT <feast@test.co.uk>: DNSBL listed at sbl-xbl.spamhaus.org What I am trying to do is be able to print x amount of columns after a certain part of the line say F= grep... (1 Reply)
Discussion started by: casseyjon
1 Replies

4. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

5. Shell Programming and Scripting

print through AWK

Hi friends I need one help from you . I want to print name='JACK' through . how can i make it . awk '{print "name=jack"}' it ll print name=JACK (6 Replies)
Discussion started by: imipsita.rath
6 Replies

6. Shell Programming and Scripting

Print using awk

Hi.. I have two files. contents of the files are as below. header1.dat ------------- This is a header record. header2.dat ------------- This is a header record. Date:2011-01-05 I am executing the below scripts. HEADER1=`cat header1.dat` HEADER2=`cat header2.dat` awk 'BEGIN... (2 Replies)
Discussion started by: 46019
2 Replies

7. UNIX for Advanced & Expert Users

awk print help

In this: $ awk '{ print "var is", var }' var=TEST file1 What does the print part do? { print "var is", var } (4 Replies)
Discussion started by: cokedude
4 Replies

8. Shell Programming and Scripting

AWK print AWK command

awk '{print "awk '{sub(/pdb_00/,"pdb_"$0"_00"); print}' pdb_"$0"_00.namd > tempo"; print "mv tempo pdb_"$0"_00.namd"}' datA2.dat > copy_script2.bash This works when trying to print 'sed etc. etc' but if I switch to using AWK to print a set of AWK commands it doesn't work... e.g. this... (3 Replies)
Discussion started by: chrisjorg
3 Replies

9. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

10. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies
ID(1)									FSF								     ID(1)

NAME
id - print real and effective UIDs and GIDs SYNOPSIS
id [OPTION]... [USERNAME] DESCRIPTION
Print information for USERNAME, or the current user. -a ignore, for compatibility with other versions -g, --group print only the effective group ID -G, --groups print all group IDs -n, --name print a name instead of a number, for -ugG -r, --real print the real ID instead of the effective ID, with -ugG -u, --user print only the effective user ID --help display this help and exit --version output version information and exit Without any OPTION, print some useful set of identified information. AUTHOR
Written by Arnold Robbins and David MacKenzie. REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>. COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU- LAR PURPOSE. SEE ALSO
The full documentation for id is maintained as a Texinfo manual. If the info and id programs are properly installed at your site, the com- mand info id should give you access to the complete manual. id (coreutils) 4.5.3 February 2003 ID(1)
All times are GMT -4. The time now is 09:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy