Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk - remove row if specific field is empty/blank
Top Forums Shell Programming and Scripting awk - remove row if specific field is empty/blank Post 302617453 by Corona688 on Monday 2nd of April 2012 04:40:19 PM
Old 04-02-2012
awk obviously does what you want:

Code:
$ printf "\tASDF\n" | awk -F'\t' '$1' # Ignore lines where first field is blank

$

So, your data doesn't seem to be what you think it is.As such, using a different utility won't do what you want either -- not until you figure out what you actually need.

Could you attach a sample of your actual data?
This User Gave Thanks to Corona688 For This Post:
charles33
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk scrip to remove empty field

Hi I have a file which looks like this name: Sally group: Group4 name: Tim group: Group1 name: Dan group: Group2 name: Chris group: Group3 name: Peter group: name: Fred group: name: Mary group: Group2 Well I want to get rid of the... (4 Replies)
Discussion started by: bombcan
4 Replies

2. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Hi, I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it. Here is how the text file looks: _______________________________________________________ DEVICE STATUS INFORMATION FOR LOCATION 1: OPER STATES: Disabled E:Enabled ... (5 Replies)
Discussion started by: Issemael
5 Replies

3. Shell Programming and Scripting

Using sed to remove lines where field is empty

I was just looking at this post: https://www.unix.com/shell-programming-scripting/22893-delete-multiple-empty-lines.html. and I am looking to achieve the same with sed. So the idea is to delete lines from a file where a certain field has no value. Inputfile: EMID MMDDYY HOURS JOB EMNAME 0241... (4 Replies)
Discussion started by: figaro
4 Replies

4. UNIX for Dummies Questions & Answers

remove empty field

Hi all ! I'm sure it is a basic question but I didn't find any threads that fit my need. How to remove empty fields with awk? Or in other words, how to shift all the fields after an empty field on the left? input: 1|2||3|4|5||6 wanted: 1|2|3|4|5|6 I tried: awk '{for(i=1; i<=NF;... (7 Replies)
Discussion started by: lucasvs
7 Replies

5. Shell Programming and Scripting

how to remove tab space only in the column of a specific row

Hi, I need help to remove tab delimited space in the $2 of a specific row. My file is like this:- file1.txt No_1 4 139 156 No_1 5 161 205 No_4 91 227 212 No_19 254 243 263 No_19 645 249 258 No_19 101 2492 2635 No_90 8 277 288... (5 Replies)
Discussion started by: redse171
5 Replies

6. Shell Programming and Scripting

Trying to remove duplicates based on field and row

I am trying to see if I can use awk to remove duplicates from a file. This is the file: -==> Listvol <== deleting /vol/eng_rmd_0941 deleting /vol/eng_rmd_0943 deleting /vol/eng_rmd_0943 deleting /vol/eng_rmd_1006 deleting /vol/eng_rmd_1012 rearrange /vol/eng_rmd_0943 ... (6 Replies)
Discussion started by: newbie2010
6 Replies

7. Shell Programming and Scripting

How to remove empty field in a text file?

Hi all, I want to remove empty field in a text file. I tried to used sed. But it failed. Input: LG10_PM_map_19_LEnd 1000560 G AG AG LG10_PM_map_19_LEnd 1005621 G AG LG10_PM_map_19_LEnd 1011214 A AG AG LG10_PM_map_19_LEnd 1011673 T CT CT ... (3 Replies)
Discussion started by: huiyee1
3 Replies

8. UNIX for Dummies Questions & Answers

Using awk to remove duplicate line if field is empty

Hi all, I've got a file that has 12 fields. I've merged 2 files and there will be some duplicates in the following: FILE: 1. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, 100 2. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, (EMPTY) 3. CDC, 54321, TEST3,... (4 Replies)
Discussion started by: tugar
4 Replies

9. Shell Programming and Scripting

awk to remove lines in file if specific field matches

I am trying to remove lines in the target.txt file if $5 before the - in that file matches sorted_list. I have tried grep and awk. Thank you :). grep grep -v -F -f targets.bed sort_list grep -vFf sort_list targets awk awk -F, ' > FILENAME == ARGV {to_remove=1; next} > ! ($5 in... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

Using awk to change a specific column and in a specific row

I am trying to change the number in bold to 2400 01,000300032,193631306,190619,0640,1,80,,2/ 02,193631306,000300032,1,190618,0640,CAD,2/ I'm not sure if sed or awk is the answer. I was going to use sed and do a character count up to that point, but that column directly before 0640 might... (8 Replies)
Discussion started by: juggernautjoee
8 Replies

LEARN ABOUT XFREE86

cachefslog

cachefslog(1M)						  System Administration Commands					    cachefslog(1M)

NAME

       cachefslog - Cache File System logging

SYNOPSIS

       cachefslog [-f logfile | -h]  cachefs_mount_point

DESCRIPTION

       The  cachefslog	command displays where CacheFS statistics are being logged. Optionally, it sets where CacheFS statistics are being logged,
       or it halts logging for a cache specified by cachefs_mount_point. The cachefs_mount_point argument is a mount point of a cache file system.
       All file systems cached under the same cache as cachefs_mount_point will be logged.

OPTIONS

       The following options are supported. You must be super-user to use the -f and -h options.

       -f logfile      Specify the log file to be used.

       -h	       Halt logging.

OPERANDS

       cachefs_mount_point     A mount point of a cache file system.

USAGE

       See largefile(5) for the description of the behavior of cachefslog when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).

EXAMPLES

       Example 1: Checking the Logging of a directory.

       The example below checks if the directory /home/sam is being logged:

       example% cachefslog /home/sam
       not logged: /home/sam

       Example 2: Changing the logfile.

       The example below changes the logfile of  /home/sam to /var/tmp/samlog:

       example# cachefslog -f /var/tmp/samlog /home/sam
       /var/tmp/samlog: /home/sam

       Example 3: Verifying the change of a logfile.

       The example below verifies the change of the previous example:

       example% cachefslog /home/sam
       /var/tmp/samlog: /home/sam

       Example 4: Halting the logging of a directory.

       The example below halts logging for the /home/sam directory:

       example# cachefslog -h /home/sam
       not logged: /home/sam

EXIT STATUS

       The following exit values are returned:

       0	       success

       non-zero        an error has occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       cachefsstat(1M), cachefswssize(1M), cfsadmin(1M), attributes(5), largefile(5)

DIAGNOSTICS

       Invalid path    It is illegal to specify a path within a cache file system.

SunOS 5.10							    7 Feb 1997							    cachefslog(1M)
All times are GMT -4. The time now is 02:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy