Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to delete files with no records?
Special Forums UNIX and Linux Applications How to delete files with no records? Post 302389970 by sangharsh on Tuesday 26th of January 2010 01:54:54 PM
Old 01-26-2010
How to delete files with no records?
Hi,

I have a file whose size is not zero but it has no records and another which has records. I want to delete all the files that have no records in it (even if size > 0). How do I do it?
I have tried the below option

Code:
#!/bin/ksh
 temp1 = $(wc -l < INVX102C.sf)
 if [ ${temp1} -gt 0]; then
 echo "Data file"
 else
 echo "Empty file"
 fi
 EOJ

But this gives me error as "test: ] missing"
Please advise how can I get my result.
Last edited by Scott; 01-26-2010 at 03:03 PM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Hai delete the records

Hai all i want to grep the particular pattern and move the mathing records to torget file and delete the matching recodrs from source file. patterns are position based, like 13413432,aaaaaaa,dsfdddddd,34234324,22224555 13413432,aaaaaaa,dsfdddddd,12234324,11222455 i want to move the... (1 Reply)
Discussion started by: readycpbala
1 Replies

2. Shell Programming and Scripting

delete records from a file

I have a big file with "|" delimiter. I want to delete all the records that have 'abc' in the 2nd field. How can i do that? I am not abe to open it in VI that is why i need to do it from outside. Please suggest (6 Replies)
Discussion started by: dsravan
6 Replies

3. UNIX for Advanced & Expert Users

delete records using line number(NR)

Hai I have a flat file which contains more than 6 crore lines or records. I want to delete only one line, using line number. For example I want to delete 414556 th line . How to do this using sed or awk command. thanks (3 Replies)
Discussion started by: tkbharani
3 Replies

4. Shell Programming and Scripting

how to delete records with the given line numbers

I have a file which has about 10000 records and I need to delete about 50 records from the file. I know line numbers and am using sed '134,1357,......d' filename > new file. It does not seem to be working. Please Advice (5 Replies)
Discussion started by: mad_man12
5 Replies

5. Shell Programming and Scripting

Compare two files with different number of records and output only the Extra records from file1

Hi Freinds , I have 2 files . File 1 |nag|HYd|1|Che |esw|Gun|2|hyd |pra|bhe|3|hyd |omu|hei|4|bnsj |uer|oeri|5|uery File 2 |nag|HYd|1|Che |esw|Gun|2|hyd |uer|oi|3|uery output : (9 Replies)
Discussion started by: i150371485
9 Replies

6. Shell Programming and Scripting

Delete records within a file upon a condition

Hi Friends, I have the following file, cat input chr1 1000 2000 chr1 600 699 chr1 701 1000 chr1 600 1710 chr2 900 1800 Now, I would like to see the difference of Record1.Col2 - Record2.Col2 Record1.Col2 - Record2.Col3 Record1.Col3 - Record2.Col2 Record1.Col3 - Record2.Col3 ... (1 Reply)
Discussion started by: jacobs.smith
1 Replies

7. Shell Programming and Scripting

Delete the records from table

Hi, Can any one help me... the records are not deleting when I run the below script. But if I issue the same delete command manually, the records are getting deleted. script: #!/bin/ksh USAGE_STRING="USAGE $0 " if then echo "SORRY you need to be user 'mqm'. Only 'mqm' has... (5 Replies)
Discussion started by: zxcjggu708
5 Replies

8. Shell Programming and Scripting

Delete records by string and position

How do i delete the records when we have string "abcd" at position 21 to 24. The file is huge in size. Any help is appreciated. Sample data given below eiojfcdf oijjfdm ijdabcd234vffmv eojfirr jfdiopem ijaabb456irkmd aodniiuielc uejdocvoabcd957wpdjf (4 Replies)
Discussion started by: zooby
4 Replies

9. Shell Programming and Scripting

Delete db records from shell script

Hello Mates, I would request your help in a shell script, simply I need to delete some matching db table records (rows) to ones in a given file: ------------------------------ #!/bin/bash SQL="delete from numberlist where msidn='';" MYSQL_USER="<your-user>"... (4 Replies)
Discussion started by: EAGL€
4 Replies

10. UNIX for Beginners Questions & Answers

Delete records that do not belong to that day

i have a requirement to delete records that do not belong to that day. For example in a file that came on July 31st ,2018 there are records that belong to Aug 1st,2018 as well and I want to find and delete those records. I want to delete anything with 01-Aug-2018. I have several files like that. I... (6 Replies)
Discussion started by: Priya
6 Replies

LEARN ABOUT DEBIAN

globus-gram-audit

GLOBUS-GRAM-AUDIT(8)						  GRAM5 Commands					      GLOBUS-GRAM-AUDIT(8)

NAME

       globus-gram-audit - Load GRAM4 and GRAM5 audit records into a database

SYNOPSIS

       globus-gram-audit [--conf CONFIG_FILE] [[--create] | [--update=OLD-VERSION]] [--check] [--delete] [--audit-directory AUDITDIR] [--quiet]

DESCRIPTION

       The globus-gram-audit program loads audit records to an SQL-based database. It reads $GLOBUS_LOCATION/etc/globus-job-manager.conf by
       default to determine the audit directory and then uploads all files in that directory that contain valid audit records to the database
       configured by the globus_gram_job_manager_auditing_setup_scripts package. If the upload completes successfully, the audit files will be
       removed.

       The full set of command-line options to globus-gram-audit consist of:

       --conf CONFIG_FILE
			       Use CONFIG_FILE instead of the default from the
			       configuration file for audit database
			       configuration.
       --check
			       Check whether the insertion of a record was
			       successful by querying the database after
			       inserting the records. This is used in tests.
       --delete 	       Delete audit records from the database right
			       after inserting them. This is used in tests to
			       avoid filling the databse with test records.
       --audit-directory DIR   Look for audit records in DIR, instead of looking
			       in the directory specified in the job manager
			       configuration. This is used in tests to control
			       which records are loaded to the database and then
			       deleted.
       --query SQL	       Perform the given SQL query on the audit
			       database. This uses the database information from
			       the configuration file to determine how to
			       contact the database.
       --quiet		       Reduce the amount of output for common
			       operations.

FILES

       The globus-gram-audit uses the following files (paths relative to $GLOBUS_LOCATION.

       etc/globus-gram-job-manager.conf
					  GRAM5 job manager configuration. It includes the
					  default path to the audit directory
       etc/globus-gram-audit.conf
					  Audit configuration. It includes the information
					  needed to contact the audit database.

University of Chicago						    08/30/2011						      GLOBUS-GRAM-AUDIT(8)
All times are GMT -4. The time now is 08:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy