Removing blank columns from a file

10 More Discussions You Might Find Interesting

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

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

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

4. 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 +...

5. 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:

6. Shell Programming and Scripting

Removing blank space in file

TT0000013101257 | JCJMMUJMMUB018 ...

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

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

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

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

LEARN ABOUT PHP

trim

TRIM(3) 								 1								   TRIM(3)

trim - Strip whitespace (or other characters) from the beginning and end of a string

SYNOPSIS

       string trim (string  $str, [string  $character_mask = " 0r B"])

DESCRIPTION

	This  function	returns  a  string with whitespace stripped from the beginning and end of $str. Without the second parameter, trim(3) will
       strip these characters:

	      o " " (ASCII
		32 ( 0x20)), an ordinary space.

	      o "	" (ASCII
		9 ( 0x09)), a tab.

	      o "
" (ASCII
		10 ( 0x0A)), a new line (line feed).

	      o "
" (ASCII
		13 ( 0x0D)), a carriage return.

	      o "" (ASCII
		0 ( 0x00)), the NUL-byte.

	      o "x0B" (ASCII
		11 ( 0x0B)), a vertical tab.

PARAMETERS

	      o $str
		- The string that will be trimmed.

	      o $character_mask
		- Optionally, the stripped characters can also be specified using the $character_mask parameter. Simply list all  characters  that
		you want to be stripped. With .. you can specify a range of characters.

RETURN VALUES

	The trimmed string.

EXAMPLES

       Example #1

	      Usage example of trim(3)

	      <?php

	      $text   = "		These are a few words :) ...  ";
	      $binary = "x09Example stringx0A";
	      $hello  = "Hello World";
	      var_dump($text, $binary, $hello);

	      print "
";

	      $trimmed = trim($text);
	      var_dump($trimmed);

	      $trimmed = trim($text, " 	.");
	      var_dump($trimmed);

	      $trimmed = trim($hello, "Hdle");
	      var_dump($trimmed);

	      $trimmed = trim($hello, 'HdWr');
	      var_dump($trimmed);

	      // trim the ASCII control characters at the beginning and end of $binary
	      // (from 0 to 31 inclusive)
	      $clean = trim($binary, "x00..x1F");
	      var_dump($clean);

	      ?>

	      The above example will output:

	      string(32) "	  These are a few words :) ...	"
	      string(16) "    Example string
	      "
	      string(11) "Hello World"

	      string(28) "These are a few words :) ..."
	      string(24) "These are a few words :)"
	      string(5) "o Wor"
	      string(9) "ello Worl"
	      string(14) "Example string"

       Example #2

	      Trimming array values with trim(3)

	      <?php
	      function trim_value(&$value)
	      {
		  $value = trim($value);
	      }

	      $fruit = array('apple','banana ', ' cranberry ');
	      var_dump($fruit);

	      array_walk($fruit, 'trim_value');
	      var_dump($fruit);

	      ?>

	      The above example will output:

	      array(3) {
		[0]=>
		string(5) "apple"
		[1]=>
		string(7) "banana "
		[2]=>
		string(11) " cranberry "
	      }
	      array(3) {
		[0]=>
		string(5) "apple"
		[1]=>
		string(6) "banana"
		[2]=>
		string(9) "cranberry"
	      }

NOTES

       Note

	      Possible gotcha: removing middle characters

	       Because	trim(3)  trims	characters  from  the  beginning and end of a string, it may be confusing when characters are (or are not)
	      removed from the middle.	trim('abc', 'bad') removes both 'a' and 'b' because it trims 'a' thus moving 'b' to the beginning to  also
	      be trimmed. So, this is why it "works" whereas trim('abc', 'b') seemingly does not.

SEE ALSO

       ltrim(3), rtrim(3), str_replace(3).

PHP Documentation Group 														   TRIM(3)

Shell Programming and Scripting