parsing log files, removing spaces and replace with commas Post: 302323808

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

removing commas from text file

Dear all I have a file which looks like this xxxxxxxxxxxxxx,xxx,xxxxxxxxxx xxxxxxxxxxxxxx,xxx,xxxxxxxxxx etc basically 14 characters then a comma, three characters, then a comma then 10 characters. We are uploading this file to our mainframe and they want the commas removed, so it...

2. Shell Programming and Scripting

Removing trailing spaces from delimited files

3. Programming

Removing empty spaces and adding commas

I have a file which contains numbers as follows: 1234 9876 6789 5677 3452 9087 4562 1367 2678 7891 I need to remove the empty spaces and add commas between the numbers like: 1234,9876,6789,5677,3452, 9087,4562,1367,2678,7891 Can anyone tell me the command to do...

4. Linux

How do i remove commas(,) & spaces

Hey guys, I am very much new to shell scripts. So you ppl may feel that i am asking stupid question here. :D 1. I am using command line argument as an input variable. The user gets this value in his mail from client which has commas n spaces (Eg. 12,34,56,789) and the scripts...

5. Shell Programming and Scripting

Need help in removing commas

i have the below line as output from a script. I want to delete the string "," and get the output without comma, cat D* | grep "bytes free" | awk '{print $3}' | ????? output: 40,966,189,056 Desired O/P: 40966189056

6. Shell Programming and Scripting

Help with sed and replacing white spaces with commas

Dear all, I am in a bit of a quandary. I have 400 text files which I need to edit and output in a very specific way. Here is a sample text file copied from gedit ... The columns will come out a bit messed up but when I cat <file>, it gives a table with six columns (0-28, tot lob vol, vcsf,...

7. UNIX for Dummies Questions & Answers

Removing blank spaces from text files in UNIX

Hello, I am an super newbie, so forgive my sheer ignorance. I have a series of text files formatted as follows (just showing the header and first few lines): mean_geo mean_raw lat lon 0.000 0 -70.616 163.021 0.000 0 -70.620 163.073 0.000 ...

8. Shell Programming and Scripting

Help with removing additional commas in string

Hi Experts, I have below strings hello,hi,,,,,,start date age,code,,,,,61,season I am trying to format this string to hello,hi,start date age,code,61,season Can anyone please help me in achieving this? Kind Regards, RB

9. Shell Programming and Scripting

Removing just the trailing commas :-(

Hi all, I haven't needed to do any shell based editing for nearly 20 years, and no amount of searching around has found me a solution to this very simple problem :-( I have a csv file. Some lines have three commas at the end. This means the invoice hasn't been paid. I'd like to use sed / grep...

10. UNIX for Beginners Questions & Answers

Removing commas from CSV file

Hi I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table. The content looks this: a,b,c,c2,c3,,,,,,,,,,,d,e I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as...

LEARN ABOUT PHP

str_replace

STR_REPLACE(3)								 1							    STR_REPLACE(3)

str_replace - Replace all occurrences of the search string with the replacement string

SYNOPSIS

       mixed str_replace (mixed  $search, mixed  $replace, mixed  $subject, [int  &$count])

DESCRIPTION

	This function returns a string or an array with all occurrences of $search in $subject replaced with the given $replace value.

	If you don't need fancy replacing rules (like regular expressions), you should always use this function instead of preg_replace(3).

PARAMETERS

	If  $search and $replace are arrays, then str_replace(3) takes a value from each array and uses them to search and replace on $subject. If
       $replace has fewer values than $search, then an empty string is used for the rest of  replacement  values.  If  $search	is  an	array  and
       $replace is a string, then this replacement string is used for every value of $search. The converse would not make sense, though.

	If $search or $replace are arrays, their elements are processed first to last.

	      o $search
		- The value being searched for, otherwise known as the needle. An array may be used to designate multiple needles.

	      o $replace
		- The replacement value that replaces found $search values. An array may be used to designate multiple replacements.

	      o $subject
		-  The	string or array being searched and replaced on, otherwise known as the haystack.  If $subject is an array, then the search
		and replace is performed with every entry of $subject, and the return value is an array as well.

	      o $count
		- If passed, this will be set to the number of replacements performed.

RETURN VALUES

	This function returns a string or an array with the replaced values.

EXAMPLES

       Example #1

	      Basic str_replace(3) examples

	      <?php
	      // Provides: <body text='black'>
	      $bodytag = str_replace("%body%", "black", "<body text='%body%'>");

	      // Provides: Hll Wrld f PHP
	      $vowels = array("a", "e", "i", "o", "u", "A", "E", "I", "O", "U");
	      $onlyconsonants = str_replace($vowels, "", "Hello World of PHP");

	      // Provides: You should eat pizza, beer, and ice cream every day
	      $phrase  = "You should eat fruits, vegetables, and fiber every day.";
	      $healthy = array("fruits", "vegetables", "fiber");
	      $yummy   = array("pizza", "beer", "ice cream");

	      $newphrase = str_replace($healthy, $yummy, $phrase);

	      // Provides: 2
	      $str = str_replace("ll", "", "good golly miss molly!", $count);
	      echo $count;
	      ?>

       Example #2

	      Examples of potential str_replace(3) gotchas

	      <?php
	      // Order of replacement
	      $str     = "Line 1
Line 2
Line 3
Line 4
";
	      $order   = array("
", "
", "
");
	      $replace = '<br />';

	      // Processes 
's first so they aren't converted twice.
	      $newstr = str_replace($order, $replace, $str);

	      // Outputs F because A is replaced with B, then B is replaced with C, and so on...
	      // Finally E is replaced with F, because of left to right replacements.
	      $search  = array('A', 'B', 'C', 'D', 'E');
	      $replace = array('B', 'C', 'D', 'E', 'F');
	      $subject = 'A';
	      echo str_replace($search, $replace, $subject);

	      // Outputs: apearpearle pear
	      // For the same reason mentioned above
	      $letters = array('a', 'p');
	      $fruit   = array('apple', 'pear');
	      $text    = 'a p';
	      $output  = str_replace($letters, $fruit, $text);
	      echo $output;
	      ?>

NOTES

       Note

	      This function is binary-safe.

       Caution

	      Replacement order gotcha

	       Because str_replace(3) replaces left to right, it might replace a previously inserted value when doing multiple	replacements.  See
	      also the examples in this document.

       Note

	       This function is case-sensitive. Use str_ireplace(3) for case-insensitive replace.

SEE ALSO

       str_ireplace(3), substr_replace(3), preg_replace(3), strtr(3).

PHP Documentation Group 													    STR_REPLACE(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

removing commas from text file

Discussion started by: hcclnoodles

2. Shell Programming and Scripting

Removing trailing spaces from delimited files

Discussion started by: djkane

3. Programming

Removing empty spaces and adding commas

Discussion started by: jazz

4. Linux

How do i remove commas(,) & spaces

Discussion started by: anushree.a