I have a file abc.dat which is a empty file. But it has null record in first line. I need to identify this unique file and handle it separately.
scenario 1:
scenario 2:
scenario 3:
If the file has null record in it
then echo "empty file with null record" -- abc.dat
else echo "empty file" -- pqr.dat
else echo "file has data in it" -- xyz.dat
Can anyone help me out?
Last edited by RudiC; 06-30-2016 at 05:58 AM..
Reason: Changed ICODE to CODE tags.
Okay i've got some code which reads a text file and loops through it and there a few if statements inside where one is failing (the one bolded).
Basically the acc column contains a list of three digit access codes, some though have null records (i.e nothing in the field) so what I want to do is... (3 Replies)
Hi
Wrote the below script to identify the empty directories ,when executing the below showing that directory is not empty but the directories are empty.Please help to identify the empty directories
33 is not empty
33 is not empty
33 is not empty
33 is not empty
for file in `find .... (5 Replies)
Hi,
I need to check for value not equal (<>) to 21 and not equal empty or null values.
Please modify this script
if
then
echo "$VALUE,$BSC_NAME,$BSC_ID" > $OUT_FILE/power_up.out
end if
TQ (5 Replies)
hi
I m executing a shell script in which records are to be fetched from a table. If the sql that is running empty result set it is displaying "table null is empty !". I dont want this msg on the standard output. COuld you please help me in this regard (3 Replies)
Hi all
I have a file that i'm running and exec(cat ./dat) against..and putting its contents into any array, then doing an exploding the array into a multi-dimension array...
The 15 multi-dimensional arrays have elements that are null/empty, I would like to remove/unset these elements and then... (2 Replies)
hi
i have record looks like below
1,US
I want to add empty field to the record as below
1, , , ,US
how i can do it using awk ?
i tried with awk its not working
awk '{ print $1", ,"$2 }' filename > file 1 (2 Replies)
Hello,
My script has a trailer record(TR).
Now I need to implement a logic, if TR is missed on the file it should generate me an email stating TR was not on the file..
Kindly help. (15 Replies)
I am trying to use awk to identify and print out records in fields that are empty along with which line they are in. I hope the awk below is close, it runs but nothing results. Thank you :).
awk
awk -F'\t' 'FNR==NR ~ /^*$/ { print "NR is empty" }' file
file
123 GOOD ID 45... (3 Replies)
Hi All
My requirement is to find the null values in particular column of a file and reject it in case if it contains null values. But the challenge is that I want a common command which can be used across different file, as the position of the column we need to check for different file may get... (14 Replies)
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 DEBIAN
dbfdump
SHAPELIB(1) User Commands SHAPELIB(1)NAME
dbfdump - dump xBase DBF files as text
SYNOPSIS
dbfdump [-h] [-m] [-r] file
DESCRIPTION
Dumps the contents of file to standard output. The first line contains the field names appearing in file, and each of the following lines
contains the field values of a record. Field names and values are padded by spaces to their field widths. Empty fields are printed as the
string "(NULL)".
OPTIONS -h Prints the column field definitions before other output. Each field definition consists of a line of the form
Field: index, Type=type, Title=`name', Width=width, Decimals=precision
where index is the zero offset column number of the field; the type indicates the datatype of the field value and is either "Inte-
ger", "Real" or "String"; name is the field's name; width is the number of bytes reserved for the field's value; and precision is
the number of decimal places of precision for "Real" type fields, and is zero for "Integer" and "String" type fields.
-m Prints each record in multiline format separated by empty lines. The first line of a record gives the number of the record in the
form
Records: record_index
where record_index is the zero offset number of the record in the file, and then each field of the record appears on its own line in
the format
name: value
-r Prints the exact bytes occurring in file for field values and suppresses printing "(NULL)" for empty values.
EXIT STATUS
0 Successful program execution.
1 Missing file argument.
2 Failed to open file.
3 There are no fields in file.
DIAGNOSTICS
The following diagnostics may be issued on stdout:
DBFOpen(file,"r") failed.
There are no fields in this table!
AUTHORS
Frank Warmerdam (warmerdam@pobox.com) is the maintainer of the shapelib shapefile library. Joonas Pihlaja (jpihlaja@cc.helsinki.fi) wrote
this man page.
BUGS
Unless the -r option is given, values in numeric fields that overflow the int or double types of the C language are printed as plus or
minus a huge number. For integer fields the huge value is HUGE_VALL from <stdlib.h> and for real fields it is HUGE_VALF.
SEE ALSO dbf_dump(1), dbfcreate(1), dbfadd(1), shpadd(1), shpcreate(1), shpdump(1), shprewind(1)shapelib OCTOBER 2004 SHAPELIB(1)