08-13-2007
Removing Null data in output
Hello all,
I have a script that has an infile with system package information. For the most part the script is looking well. The only thing i need help is in testing for null entries and removing null data.
#!/usr/bin/ksh
for i in `cat /mwncps/bin/eco_pack`
do
NAME=`pkginfo -l | grep $i | grep 'NAME' | awk '{ print $5 }'`
VER=`pkginfo | grep $i | grep version | awk 'BEGIN {OFS=" "}{gsub(/version:/,"") ;}{ print $7 }'`
echo "`hostname`,"$NAME","$VER""
done
The output now looks like this
hostname,,
hostname,,
hostname,package,version <-- this part of the output is correct
hostname,package,version
hostname,package,version
hostname,package,version
hostname,, <-- this will need to be removed completely
hostname,,
I welcome your feedback
Regards,
Al
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am having a "|" delimited flat file and I have to pick up all the records with the 2nd field having null value. Please suggest. (3 Replies)
Discussion started by: dsravan
3 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I am working on a script to measure the read performance of a busybox environment. The logical choice is to use a command line like:
(time cp * /dev/null) 2> /tmp/howlong.txt
Ah, the rub is cp or /dev/null will only accept a single file at a time.
The result in the txt file is and... (1 Reply)
Discussion started by: stevesmo
1 Replies
3. UNIX for Dummies Questions & Answers
hello,
when I load a data from text file all the values become NULL in the table.
Please help me with this problem.
Thanks
sheen (15 Replies)
Discussion started by: sheen
15 Replies
4. Shell Programming and Scripting
Hi all,
I have the following script, but are not too sure about the syntax to complete the script.
In essence, the script must connect to a SFTP server at a client site with username and password located in a file on my server.
Then change to the appropriate directory.
Pull the data to the... (1 Reply)
Discussion started by: codenjanod
1 Replies
5. Shell Programming and Scripting
Hello,
I'm trying to send the error output of a 'cat' operation to /dev/null like this:
cat /dirA/dirB/temp*.log > /dirA/dirB/final.log 2>/dev/null
This works perfectly in a terminal, but not when placed in a script.
If there are no files matching temp*.log the script outputs an error... (7 Replies)
Discussion started by: Nils88
7 Replies
6. Shell Programming and Scripting
Hi Guys,
Please help me.. it is urgent. I am writing a perl script to capture command output and redirect it to a logfile.At the same i want to check the return code of the command and log it if the command is not succesful in my logfile.. Here is my code, it is working but system command inside... (2 Replies)
Discussion started by: sriramperumalla
2 Replies
7. Shell Programming and Scripting
Hi,
I have following data in a file
5~6.14~S~N~N~0.~4565~134~6584
~6.13~H~N~N~0.~4578~0~6587
2~6.14~S~N~N~0.~4565~134~6584
~3.13~H~N~N~0.~4578~0~6587
-~6.14~S~N~N~0.~4565~134~6584
~7.13~H~N~N~0.~4578~0~6587
I want the output as
5~6.14~S~N~N~0.~4565~134~6584... (2 Replies)
Discussion started by: sol_nov
2 Replies
8. Shell Programming and Scripting
I'm using an text-to-speech synthesis in a script, and I need to redirect it's output to /dev/null
how can I do that ? And how to redirect the stream to his normal output then (sound card ) ?
thankx (2 Replies)
Discussion started by: firelink
2 Replies
9. Shell Programming and Scripting
I am using ISQL command in ksh script.
Suppose if i get NULL value from the query which i run,how can i handle it?
I am getting a NULL result set and the following error is coming.
############### output of isql command for getting the sum of JEs ################
-----------
NULL... (4 Replies)
Discussion started by: Sharma331
4 Replies
10. UNIX for Beginners Questions & Answers
I am working an some if then statements for a script.
I want to be able to check for alpha characters or empty out put then exit out.
if ]];
echo "Serial Number Invaild"
then exit 3;
How do I account if the output is empty or null in this in this statement.
Many thanks (6 Replies)
Discussion started by: andysensible
6 Replies
LEARN ABOUT OPENSOLARIS
shcomp
shcomp(1) User Commands shcomp(1)
NAME
shcomp - compile a ksh93 shell script
SYNOPSIS
shcomp [-nv] [infile [outfile]]
shcomp -D [infile [outfile]]
DESCRIPTION
If the -D option is not specified, shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 reads and
executes with the same effect as the original script.
Aliases are processed as the script is read. Alias definitions whose value requires variable expansion will not work correctly.
OPTIONS
The following options are supported:
-D Generate a list of strings that need to be placed in a message catalog for internationalization.
--dictionary
With this option, all double quoted strings that are preceded by $ are printed, one literal per line. A literal $"foo"
prints "foo" in the output. These are the messages that need to be translated to locale specific versions for internation-
alization.
-n Display warning messages for obsolete or non-conforming constructs.
--noexec
-v Display input from infile onto standard error as it reads it.
--verbose
OPERANDS
The following operands are supported:
infile Specifies the name of the file that contains the shell script to be used as input.
If infile is omitted, the shell script is read from standard input.
outfile Specifies the name of the output file.
If outfile is omitted, both modes write their results to standard output.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
|Interface Stability |See below. |
+-----------------------------+-----------------------------+
The command-line interface and the system variables are Committed. The compiled shell code format is Private. The output of the -D option
is Volatile.
SEE ALSO
ksh93(1), attributes(5)
SunOS 5.11 27 Jan 2009 shcomp(1)