Sponsored Content
Top Forums Shell Programming and Scripting Verify the null filed of the text file Post 302894098 by RavinderSingh13 on Monday 24th of March 2014 03:42:45 AM
Old 03-24-2014
Hello,

Please use the following for same.

Code:
awk -F"|" '{for(i=0;i<=NF;i++) {if($i == "") {print "field " i " have NULL Value"} {a++;} }}' file_name

Ouptut will be as follows.

Code:
field 3 have NULL Value
field 4 have NULL Value
field 2 have NULL Value
field 1 have NULL Value


Thanks,
R. Singh
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to verify weather it is a ebcdic file or not

Hi all, Please tell me how to verify weather it is a ebcdic file or not . I checked with file commond but it is giving like International Language text. Regards, Chaitu (0 Replies)
Discussion started by: c_chaitanya
0 Replies

2. Shell Programming and Scripting

how do i ignore rows with first filed NULL

I have a file to load in the table, and am using SQLLDR CONTROL FILE ----------------------- LOAD DATA INFILE 'sample.txt' APPEND INTO TABLE TEMP_LOAD FIELDS TERMINATED BY '|' TRAILING NULLCOLS (FIELD1,FIELD2,FIELD3) Now i have about 10,000 lines in the file FIELD1 in the table is... (1 Reply)
Discussion started by: prash184u
1 Replies

3. Shell Programming and Scripting

KSH script -text file processing NULL issues

I'm trying to strip any garbage that may be at the end of my text file and that part is working. The problem only seems to be with the really long lines in the file. When the head command is executed I am directing the output to a new file. The new file always get a null in the 4096 position but... (2 Replies)
Discussion started by: geauxsaints
2 Replies

4. Shell Programming and Scripting

filter out all the records which are having space in the 8th filed of my file

I have a file which is having fileds separtaed by delimiter. Ex: C;4498;qwa;cghy;;;;40;;222122 C;4498;sample;city;;;;34 2;;222123 C;4498;qwe;xcbv;;;;34-2;;222124 C;4498;jj;sffz;;;;41;;222120 C;4498;eert;qwq;;;;34 A;;222125 C;4498;jj;szxzzd;;;;34;;222127 out of these records I... (3 Replies)
Discussion started by: indusri
3 Replies

5. Infrastructure Monitoring

verify ip and port are in file

Having some problems figuring out how to do this. I have a file that has a template config for my network routers and in this config is a list of my access lists. I need help finding a way to verify if a single ip or a range along with the port allowed is in the list. My biggest issue is the range... (1 Reply)
Discussion started by: numele
1 Replies

6. Shell Programming and Scripting

Redirecting standard out to /dev/null goes to file "/dev/null" instead

I apologize if this question has been answered else where or is too elementary. I ran across a KSH script (long unimportant story) that does this: if ; then CAS_SRC_LOG="/var/log/cas_src.log 2>&1" else CAS_SRC_LOG="/dev/null 2>&1" fithen does this: /usr/bin/echo "heartbeat:... (5 Replies)
Discussion started by: jbmorrisonjr
5 Replies

7. Shell Programming and Scripting

Verify the header and trailer in file

please see my requirement, I hope I am clear. (9 Replies)
Discussion started by: mirwasim
9 Replies

8. UNIX for Dummies Questions & Answers

How to find the null member or blank in the text file?

Hello All, I am new to unix scripting and wanted to know, is it possible if we find any null value or blank record in the text file. For example we have a text file with only one column and there are 90 records. But some times we will have a null value or blank row record in the text file. I... (4 Replies)
Discussion started by: Ram11111
4 Replies

9. Shell Programming and Scripting

How to replace the filed at file 1 by looking the content at file 2?

Suppose I have two file which content like this: File 1.txt Cetner 1, machine A Center 2, machine B Center 3, machine A Center 4, machine C ............................ File 2.txt machine A, 10.10.10.1 machine B,... (4 Replies)
Discussion started by: Alex Li
4 Replies
CBTEST(1)						      Quick Database Manager							 CBTEST(1)

NAME
cbtest - test cases for QDBM Cabin SYNOPSIS
cbtest sort [-d] rnum cbtest strstr [-d] rnum cbtest list [-d] rnum cbtest map [-d] rnum cbtest wicked rnum cbtest misc DESCRIPTION
The command `cbtest' is a utility for facility test and performance test. Measure the execution time of the command. This command is used in the following format. `rnum' specifies the number of records. cbtest sort [-d] rnum Perform test of sorting algorithms. cbtest sort [-d] rnum Perform test of string locating algorithms. cbtest list [-d] rnum Perform writing test of list. cbtest map [-d] rnum Perform writing test of map. cbtest wicked rnum Perform updating operations of list and map selected at random. cbtest misc Perform test of miscellaneous routines. Options feature the following. -d : read and show data of the result. This command returns 0 on success, another on failure. SEE ALSO
qdbm(3), cabin(3) AUTHOR
QDBM was written by Mikio Hirabayashi <mikio@fallabs.com>. Man Page 2005-06-01 CBTEST(1)
All times are GMT -4. The time now is 08:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy