The output is now properly obtained as below with spaces .This is expected as there are few other statements in the parent log which doesnot match the criteria.
My next requirement was to make this .txt file to excel.On searching the forum i wrote the below code
The excel is generated but not in proper format.
1. All headers came in one column
2. The space in the .txt file has occupied in excel with many cells having |
3. The last column is not displayed with value.Ex 5195,3631 etc
Can the shell convert the txt into excel.any links available further on this.Thanks.
The desired output is as follows in xcel
Last edited by Scrutinizer; 07-21-2017 at 05:12 PM..
Reason: Query to convert into excel; [mod] Added code tags
Hi friends,
I am trying to pass input from command line and trying to print that column values. (FYI: I am using ksh) My code goes like this...
#!/bin/sh
column=$1
awk '{print $'$column'}'
I execute using command like this --> ls -l | file_name parameter
Hope I am clear with my... (2 Replies)
Hello all,
Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val:
> cat getnon0file.sh
#!/bin/bash
this="getnon0file.sh"
USAGE=$this"
InFile="xyz.38"
Min="0.05"
#
awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
Hi,
Please could someone advise the issue i have with my awk command ?
my command is :
export NUM_SCENARIOS=`awk -F= '!/^#/ && /NUM_SCENARIOS/{print $2}' /home/environment.properties`
when I echo $NUM_SCENARIOS
this comes back with :
100 10
The issue I have is, there is... (9 Replies)
Hi guys,
i am trying to analyze a text file using awk and am not able to solve this issue.
This is the piece of code that I have written
BEGIN {
## Time to count MACs -> 5 seconds.
TIME_LIMIT = 5;
k = 50000;
}
## For every line.
{
time_in_seconds = $1... (2 Replies)
Hi all,
i am trying to use below command to see the output of hardware inventory, but i only see 2 first line no output of the command.
awk '/Hardware/ {print $0}' XXX_result.txt
Hardware inventory:
Hardware inventory:
any idea how to see whatever is under hardware inventory.
i... (11 Replies)
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
limit.csv data
--------------
5600050 38Nhava
400077 27Bomay
rate.txt data
-------------
38NhaVA
27BomaY
27Bomay
below is my script:
for i in `cat limit.csv`
do
b=`awk '{print $1}' $i` (4 Replies)
Hi All,
I have one file with below content
Post1:uri
Post2:urieop
Post3:urtei
I am trying to read each word seprated by delimiter with below command
Value1=$(awk -F":" '{print $1}' $HSFILE)
Value2=$(awk -F":" '{print $2}' $HSFILE)
echo $Value1
echo $Value2
It is... (5 Replies)
Hi All,
I am trying to perform certain task using awk command but the command is not returning expected output though it is running fine independently but not in for loop.
req:
1. I am searching a pattern (say pattern1) in a dated file
2. trying to search the last occurrence of the another... (11 Replies)
Hi,
Here is the output using bash profile on Linux
uptime
04:59:14 up 16 days, 4:48, 2 users, load average: 1.00, 1.00, 1.20
Here is the output using bash profile on Solaris
uptime
4:00am up 84 day(s), 22:21, 3 users, load average: 0.09, 0.10, 0.12
Now,... (4 Replies)
Discussion started by: mohtashims
4 Replies
LEARN ABOUT DEBIAN
dpkg-awk
DPKG-AWK(1) General Commands Manual DPKG-AWK(1)NAME
dpkg-awk - Utility to read a dpkg style db file
SYNOPSIS
dpkg-awk [(-f|--file) filename] [(-d|--debug) ##] [(-s|--sort) list] [(-rs|--rec_sep) ??] '<fieldname>:<regex>' ... -- <out_fieldname> ..
DESCRIPTION
dpkg-awk Parses a dpkg status file (or other similarly formatted file) and outputs the resulting records. It can use regex on the field
values to limit the returned records, it can also be told which fields to output, and it can sort the matched fields.
OPTIONS -f filename
--file filename
The file to parse. The default is /var/lib/dpkg/status.
-d [#]
--debug [#]
Each time this is specified, it increased the debug level.
-s field(s)
--sort field(s)
A space or comma separated list of fields to sort on.
-n field(s)
--numeric field(s)
A space or comma separated list of fields that should be interpreted as numeric in value.
-rs ??
--rec_sep ??
Output this string at the end of each output paragraph.
-h
--help Display some help.
fieldname
The fields from the file, that are matched with the regex given. The fieldnames are case insensitive.
out_fieldname
The fields from the file, that are output for each record. If the first field listed begins with ^, then the list of fields that
follows will NOT be output.
BUGS
Be warned that the author has only a shallow understanding of the dpkg packaging system, so there are probably tons of bugs in this pro-
gram.
This program comes with no warranties. If running this program causes fire and brimstone to rain down upon the earth, you will be on your
own.
This program accesses the dpkg database directly in places, querying for data that cannot be gotten via dpkg.
AUTHOR
Adam Heath <doogie@debian.org>
DEBIAN Debian Utilities DPKG-AWK(1)