Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing blank columns from a file
Top Forums Shell Programming and Scripting Removing blank columns from a file Post 302226271 by sumirmehta on Monday 18th of August 2008 04:21:55 PM
Old 08-18-2008
Removing blank columns from a file
Hi,

I have a sample file as shown below --

id parent name dba
----------------------------------- ----------------------------------- ---------------------------------------- ----------------------------------------
0367169 BANK OF LITHUANIA
0108949 BRATTON LTD
0214359 HALYARD RE BV
0216856 VIKING CABLE AS
0400088 DEUTSCHE BANK AG
0212256 AXA SA
0020503 O/S COUPON SETTLEMENTS
0167528 TT UK LTD


The column under the headers parent and dba are fully blank. I want to convert this file into a csv. tried using sed s/" "*" "/,/g but that removes the whole blank columns as well... any ideas ??
Last edited by sumirmehta; 08-18-2008 at 05:24 PM.. Reason: Reformatted the input file
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing blank spaces from a file?

Guys, I need some help... how can I remove the blank spaces between the lines below? (between the date and the hour fields) 21/05/07 00:05:00 99 21/05/07 00:10:01 99 21/05/07 00:15:00 99 21/05/07 00:20:00 99 21/05/07 00:25:00 99 I want to make the file... (4 Replies)
Discussion started by: dfs
4 Replies

2. UNIX for Dummies Questions & Answers

Removing blank lines in a file

Hi I have a text file that has blank lines at different places. How to remove all the blank lines in a file? Thanks Ashok (3 Replies)
Discussion started by: ashok.k
3 Replies

3. Shell Programming and Scripting

Extract columns from a file if the name dont exist put blank

Hi, I am very new to Unix script. Suppose i have a file with column header: NAME1 NAME2 Address Tel And I always need to make a file with column header: ID NAME1 NAME2 EMail Address Tel For the columns that do not exist in the file, I would still like to make a column with blank. ... (11 Replies)
Discussion started by: nightrider
11 Replies

4. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies

5. Shell Programming and Scripting

Removing blank space in file

TT0000013101257 | JCJMMUJMMUB018 ... (0 Replies)
Discussion started by: sususa
0 Replies

6. Shell Programming and Scripting

Removing blank lines from a file

Hi All, How do i remove continuos blank lines from a file. I have a file with data: abc; def; ghi; jkl; mno; pqr; In the above file, there are two blank lines. I want to remove, one out of them. My output should look like: (2 Replies)
Discussion started by: raosr020
2 Replies

7. Shell Programming and Scripting

How to sort a text file if certain columns are blank?

Dear all, I am trying to sort a text file based on column 3, 10, 11 and 12. But certain column are blank for some lines. Column 3 has to be in ascending order after sorting. Part of my input file is as follows: CN727990 1 A01 4703 5083 73.28 - A_scaffold000011 4365605 4365985 73.28 +... (10 Replies)
Discussion started by: huiyee1
10 Replies

8. Shell Programming and Scripting

Inserting blank columns in already present CSV file

Hi, i have a csv file which have headers and values of it like below : headers --> CI Ref SerialNumber LastScanDate values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000 i want to have a above csv in below format : headers --> CI Name CI Description CI Ref... (6 Replies)
Discussion started by: omkar.jadhav
6 Replies

9. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Hello, I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs. I was thinking of using sed to replace instances of double tab with blank, sed 's/\t\t//g' All of the examples... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

10. Shell Programming and Scripting

Script to find blank records in a file except for few columns

I have a file with the following format: X|High|2|GIC|DM||XHM|||6 Months X|Moderate|2|GIC|DM||XHM|||6 Months X|High|2|GCM|DM||XSF|||6 Months X|Med|2|GCM|DM||XSF|||6 Here there are ten columns but I need to print rows having blank records in any of the rows (except for 6th,8th and 9th... (10 Replies)
Discussion started by: chatwithsaurav
10 Replies

LEARN ABOUT PHP

dba_open

DBA_OPEN(3)								 1							       DBA_OPEN(3)

dba_open - Open database

SYNOPSIS

       resource dba_open (string  $path, string  $mode, [string  $handler], [mixed  $...])

DESCRIPTION

       dba_open(3) establishes a database instance for $path with $mode using $handler.

PARAMETERS

	      o $path
		- Commonly a regular path in your filesystem.

	      o $mode
		-  It is r for read access, w for read/write access to an already existing database, c for read/write access and database creation
		if it doesn't currently exist, and n for create, truncate and read/write access. The database is  created  in  BTree  mode,  other
		modes (like Hash or Queue) are not supported.  Additionally you can set the database lock method with the next char. Use l to lock
		the database with a .lck file or d to lock the databasefile itself. It is important that all of your applications do this  consis-
		tently.   If you want to test the access and do not want to wait for the lock you can add t as third character. When you are abso-
		lutely sure that you do not require database locking you can do so by using - instead of l or d. When none of d, l or -  is  used,
		dba will lock on the database file as it would with d.

	      Note

		      There  can  only	be  one  writer for one database file. When you use dba on a web server and more than one request requires
		     write operations they can only be done one after another. Also read during write is not allowed. The dba extension uses locks
		     to prevent this. See the following table:

		     DBA locking

		     +-------------+---------------+---+---+---+---+---+---+---+
		     |already open |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rl"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rlt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wl"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wlt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rd"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rdt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wd"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wdt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     +-------------+---------------+---+---+---+---+---+---+---+
		     |	not open   |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "rl" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "wl" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "rd" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "wd" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     +-------------+---------------+---+---+---+---+---+---+---+
			    ook: the second call will be successfull.

			    owait: the second call waits until dba_close(3) is called for the first.

			    ofalse: the second call returns false.

			    oillegal: you must not mix
			      "l" and "d" modifiers for $mode parameter.

	      o $handler
		-  The	name of the handler which shall be used for accessing $path. It is passed all optional parameters given to dba_open(3) and
		can act on behalf of them.

RETURN VALUES

	Returns a positive handle on success or FALSE on failure.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 4.3.0	|						    |
       |	|						    |
       |	|  It's possible to open database files  over  net- |
       |	| work	connection.  However in cases a socket con- |
       |	| nection will be used (as with http  or  ftp)	the |
       |	| connection will be locked instead of the resource |
       |	| itself. This is important to know since  in  such |
       |	| cases  locking  is simply ignored on the resource |
       |	| and other solutions have to be found. 	    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       dba_popen(3), dba_close(3).

PHP Documentation Group 													       DBA_OPEN(3)
All times are GMT -4. The time now is 03:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy