Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

remove empty field

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers remove empty field
# 8  
Old 04-06-2012
Try:
Code:
#!/usr/bin/gawk -f

BEGIN{FS=OFS="|"}

{
   <do my stuff 1>

# need to remove empty fields at this stage

   gsub(/^\||\|$/,x)
   gsub(/\|\|/,FS)

# need to keep going with FS=OFS="|"

   <do my stuff 2>
}
1

Last edited by Scrutinizer; 04-06-2012 at 05:17 AM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. Shell Programming and Scripting

How to detect empty field in awk ?

Hi ! programmers I have a need of detecting empty field in file my file looks like this 40.900|-71.600|1.6|20|1|1961|21.00|3.700||1|US|28035|10029370|31 40.900|-71.600|5.7|20|1|1961|21.00|3.700||1|US|28035|10029370|31 40.900|-71.600|7.8|20|1|1961|21.00|3.700||1|US|28035|10029370|31... (7 Replies)
Discussion started by: Dona Clara
7 Replies

4. Shell Programming and Scripting

print non empty column/field value

I have below file 25-09-2012 24-09-2012 19-09-2012 31-07-2012 30-04-2012 30-03-2012 ASIAEXFVNV N/A CEU 4 DMIRSOA N/A CAS 2 2 2 DMIRSOA N/A MIDMT 2 NFIAL22 N/A HVNY 11 11 11 NFIAL22 N/A NYAL3 11 11 11 NFIAL22 N/A NYCN 11 11 11 ... (4 Replies)
Discussion started by: manas_ranjan
4 Replies

5. Shell Programming and Scripting

awk - remove row if specific field is empty/blank

I have this text.filecharles darwin sam delight george washington johnson culper darwin sam delight micheal jackson penny lite and would like to remove the row, if the first field is blank. so the result would be: result.filecharles darwin sam ... (4 Replies)
Discussion started by: charles33
4 Replies

6. 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

7. UNIX for Dummies Questions & Answers

Count of Field for Non-Empty

Hi Guys, I wanted to count the number of records for a particular field of a file. whose fields are separated by comma"," I fI use this command. cat "filename" cut -sd "," -f13 | wc -l This shows all the lines count including the blank values for the field number 13. I wanted to count... (2 Replies)
Discussion started by: Swapna173
2 Replies

8. Shell Programming and Scripting

How to print empty line when the a field is changed

Hi all, I have this input file .. BSS01 107 Swafieh 11/06/2008 12:06:57 BSS01 111 Ramada_Hotel 12/06/2008 11:37:20 BSS01 147 Kalha_Rep 11/06/2008 19:13:39 BSS01 147 Kalha_Rep ... (9 Replies)
Discussion started by: yahyaaa
9 Replies

9. 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

10. UNIX for Dummies Questions & Answers

Shell Script using Join, empty field help!

Deleted#### (1 Reply)
Discussion started by: tibbyuk
1 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

xkballocservermap

XkbAllocServerMap(3)						   XKB FUNCTIONS					      XkbAllocServerMap(3)

NAME

       XkbAllocServerMap - Allocate and initialize an empty server map description record

SYNOPSIS

       Status XkbAllocServerMap (XkbDescPtr xkb, unsigned int which, unsigned int count_acts);

ARGUMENTS

       - xkb  keyboard description in which to allocate server map

       - which
	      mask selecting map components to allocate

       - count_acts
	      value of num_acts field in map to be allocated

DESCRIPTION

       XkbAllocServerMap  allocates  and  initializes  an  empty server map in the server field of the keyboard description specified by xkb.  The
       which parameter specifies the particular components of the server map structure to allocate, as specified in Table 1.

			 Table 1 XkbAllocServerMap Masks
       ---------------------------------------------------------------------
       Mask			   Effect
       ---------------------------------------------------------------------
       XkbExplicitComponentsMask   The min_key_code and max_key_code fields
				   of  the  xkb parameter are used to allo-
				   cate the explicit field  of	the  server
				   map.

       XkbKeyActionsMask	   The min_key_code and max_key_code fields
				   of the xkb parameter are used  to  allo-
				   cate  the  key_acts	field of the server
				   map. The count_acts parameter is used to
				   allocate  the  acts	field of the server
				   map.

       XkbKeyBehaviorsMask	   The min_key_code and max_key_code fields
				   of  the  xkb parameter are used to allo-
				   cate the behaviors field of	the  server
				   map.

       XkbVirtualModMapMask	   The min_key_code and max_key_code fields
				   of the xkb parameter are used  to  allo-
				   cate  the  vmodmap  field  of the server
				   map.

       If the server map of the keyboard description is not NULL and any fields are already allocated in the server  map,  XkbAllocServerMap  does
       not  overwrite  the  existing  values.  The  only exception is with the acts array. If the count_acts parameter is greater than the current
       num_acts field of the server map, XkbAllocServerMap resizes the acts array and resets the num_acts field accordingly.

       If XkbAllocServerMap is successful, it returns Success. Otherwise, it can return either BadMatch or BadAlloc errors.

DIAGNOSTICS

       BadAlloc       Unable to allocate storage

       BadMatch       A compatible version of Xkb was not available in the server or an argument has correct type  and	range,	but  is  otherwise
		      invalid

       BadValue       An argument is out of range

NOTES

       The  min_key_code  and max_key_code fields of the xkb parameter must be legal values. If they are not valid, XkbAllocServerMap returns Bad-
       Value.

X Version 11							   libX11 1.5.0 					      XkbAllocServerMap(3)