Our vendor produces a report that I would like to format in a particular way.
Here is the sample output from their report:
As you can see on line 5, fields 3 & 4 are running into each other. This is due to the fields being fixed width and the value being to large (I'm assuming). I do not actually know the field widths, but could probably figure it out (by counting) if needed.
What I need is to ensure that fields 3 & 4 stay separated so I can perform some calculations with them (ie. $3 * $4). Filed 3 should always be a single digit. So "if length field 3 > 1 then split field 3 into fields 3 & 4 after the first digit in field 3".
Let's say I write a simple script that contains the following:
date | awk '{print $1}'
date | awk '{print $2}'
Of course, when I run the script the output will look similar to:
Tue
Mar
What if I want my ouput to be on one line as follows:
Tue Mar
What changes would I need to... (2 Replies)
I have 2 files with sample data enclosed.
1. GL (already sorted in ascending order by Gl number)
Gl number*glname*Year*opening balance
1000*Interest Income*2006*100.00
1005*Rental Income*2006*0.00
...
2. Transactions (file is not sorted on GL number or any other field)
Branch*Year*Gl... (12 Replies)
Hi
I am fetcthing the data from the oracle database using SQLPLUS. Here is my script
#!/bin/ksh
echo `sqlplus -s <<EOF
set feedback off
set linesize 5000
set pages 0
set space 0
set echo off
set trimspool on
set colsep '|'
SELECT col1 , col2... (4 Replies)
Dear all
I require help with AWK regarding this situation
Input is :
fn1 12345
fn1 23456
fn3 231513
fn1 22325
fn3 123125
Desired output is
fn1 12345 23456 22325
fn3 231513 123125 (5 Replies)
when i try this awk its giving out put as below.
awk '!(/^$/||/--/||/selected/||/^ *$/){print $1}' tmp.txt
output
=====
1
2010-08-03-12.31.26.126000
how excluede the 1st line ? i mean i want output only 2nd line i.e 2010-08-03-12.31.26.126000; (5 Replies)
Hi;
i m running an command like;
getfacl $(find /home/fstl/testShell/ -type f -ls | awk '{print $11}')
and i m getting outpiut for all files in "testShell" folder as;
# file: home/fstl/testShell/.script1.sh.swp
# owner: root
# group: root
user:fstl:rw-
user:ajay:rw-
group:root:r--... (1 Reply)
Hi all,
I'm writing a simple awk code:
awk 'BEGIN {FS="|"};{print "Type\tNumber\ttypes\tTotal";};{print $1, "\t", $2, "\t", $3, "\t", $4, "\t";}' db_query.txt
it gives me the result:
Type Number types Total
XXX 498.0 5100.0 5274.661
Type Number types Total... (7 Replies)
Data
I was trying to write shell script which will be return the output in the below format
First i was trying to do these using sed.
sed -n '/.ksh/p' mainksh.ksh
sed -e 's/*\(.*\)/\1/g' mainksh.ksh
$RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file.
when i am... (0 Replies)
Hi ,
I was trying to find files of a particular date and did that but then I also wanted to format a field based on some condition so had put another if else in awk.
Now it is getting the files of particular date or also the files which are matching that if else condition.
find . -name "*"... (1 Reply)
i would like to format the 9 character with suffix as "0".
i tried below it doesn't work.
>a=12345
> echo $a | awk '{printf "%-09s\n",$1}'
>12345
required output is 123450000
can you guys help me out ? (7 Replies)
Discussion started by: expert
7 Replies
LEARN ABOUT NETBSD
shape_tar
SHAPE_TAR(1) General Commands Manual SHAPE_TAR(1)NAME
shape_tar - shapeTools RMS bundle up subsystem in a tar or shar archive
SYNOPSIS
shape tar[VERSIONS=<version_selection_rule>] [ARCHIVE=<filename>]
shape shar[VERSIONS=<version_selection_rule>] [ARCHIVE=<filename>]
DESCRIPTION
Shape tar and shape shar create a tar or a shar archive containing all source components of the current node in the system tree. All source
components listed in the COMPONENTS macro in the Makefile and the release identification file (VERSIONFILE) are written to the archive.
Components of subsystems are not included in the archive file.
The VERSIONS macro may be set to specify a version selection rule to be active during archive file creation. Default is most_recent,
selecting the most recent version of each component. See shape_stdrul(7) or the $(SHAPELIBPATH)/stdrules for other possible settings. You
may also use self defined version selection rules as VERSIONS.
ARCHIVE is the base name of the file where the output shall be written to. Default is $(SUBSYSTEMNAME). The output file gets the filename
extension .tar (resp. .shar). When ARCHIVE=- is given, data will be written to standard output.
SEE ALSO shape_RMS(1), shape_stdrul(7)FILES
$(SUBSYSTEMNAME).tar $(SUBSYSTEMNAME).shar
28.9.119SHAPE_TAR(1)