Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Remove unwanted white space
Top Forums Shell Programming and Scripting Remove unwanted white space Post 302650017 by sam05121988 on Friday 1st of June 2012 11:03:15 AM
Old 06-01-2012
MySQL Remove unwanted white space
Hi,

I have a very big file 25GB with information present in it like

Code:
 
$ head ind_stats
 
update index statistics pfirm001.dbo.Office using 200 values
go
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
 

update index statistics pfirm001.dbo.States using 200 values
go
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
 
 

update index statistics pfirm001.dbo.hpsipb using 200 values
go

how can i remove unwanted white spaces, keeping the spaces between words

Thanks in advance
Sam
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove unwanted data?

Hi Can any one help me remove the unwanted data? I would want to remove the complete event id 4910 ( the type there is INFO), that means, I have to remove starting from 7th - 19th lines. can any one of you please help? Thanks, (24 Replies)
Discussion started by: hitmansilentass
24 Replies

2. Shell Programming and Scripting

Remove white space at the beginning of lines

Hi! I store some data obtained with grep or awk in a file. The problem is that some lines have white space at the begining : line1 line2 line3 I use something like grep WORD INFILE >> OUTFILE awk >> OUTFILE I would love if it were possible to remove the white whitout parsing the... (4 Replies)
Discussion started by: tipi
4 Replies

3. UNIX for Dummies Questions & Answers

SED with White Space

Dear Members, Suppose i have a variable test which stores a string as below: test='John drives+++++++++a+++++car' now i want to use sed on the above variable and replace + with a white space, so that i get echo $test should give me 'john drives a car' Between... (1 Reply)
Discussion started by: sandeep_1105
1 Replies

4. Solaris

Remove unwanted packages

I got a system which was installed with SUNWCXall cluster installed on it and i want remove unwanted software like GMNOME, Java Desktop System, Staroffice and numerous other softwares .. i want to do an automated removal of these packages where its uninstalled by itself ..from the is there any... (4 Replies)
Discussion started by: fugitive
4 Replies

5. Shell Programming and Scripting

Remove unwanted lines

I have a .xml file, where i need some output. The xml file is like: Code: <?******?></ddddd><sssss>234</dfdffsdf><sdhjh>534</dfdfa>......... /Code I need the output like: code 234 534 . . . /code How can i do it? (5 Replies)
Discussion started by: anupdas
5 Replies

6. Shell Programming and Scripting

remove white space from specific columns in text file

Hello i have a text file like this: 1 AB AC AD EE 2 WE TR YT WW 3 AS UY RF YT the file is bigger , but that's an example of the data what i want to do is to merge all columns together except the first one, it will become like this : 1 ABACADEE 2 WETRYTWW 3 ASUYRFYT (8 Replies)
Discussion started by: shelladdict
8 Replies

7. Shell Programming and Scripting

How to remove unwanted strings?

Hi Guys, Can someone give me a hand on how I can remove unwanted strings like "<Number>" and "</Number>" and retain only the numbers from the input file below. INPUT FILE: <Number>10050000</Number> <Number>1001340001</Number> <Number>1001750002</Number> <Number>100750003</Number>... (8 Replies)
Discussion started by: pinpe
8 Replies

8. UNIX for Dummies Questions & Answers

filename with white space

our user creates a text file with a white space on the filename. this same file is transfered to unix via automation tool. i have a korn shell script that reads these files on a input directory and connects to oracle database to run the oracle procedures which will load the data from each of the... (2 Replies)
Discussion started by: wtolentino
2 Replies

9. Shell Programming and Scripting

Remove white space and duplicate headers

I have a file called "dsout" with empty rows and duplicate headers. DATE TIME TOTAL_GB USED_GB %USED --------- -------- ---------- ---------- ---------- 03/05/013 12:34 PM 3151.24316 2331.56653 73.988785 ... (3 Replies)
Discussion started by: Daniel Gate
3 Replies

10. Shell Programming and Scripting

Remove of white space when you have multiple column

i have file in which i want to remove white space from each column where ever it exist there is white space at the end of line. i know how to remove white space if i have only 1 column, but i have multiple columns and white space can be in any column. sed 's/ *$//' file ath-miRf10005-akr... (5 Replies)
Discussion started by: mirwasim
5 Replies

LEARN ABOUT REDHAT

mailstats

MAILSTATS(8)						      System Manager's Manual						      MAILSTATS(8)

NAME

       mailstats - display mail statistics

SYNOPSIS

       mailstats [-c] [-o] [-p] [-P] [-C cffile] [-f stfile]

DESCRIPTION

       The mailstats utility displays the current mail statistics.

       First,  the  time  at which statistics started being kept is displayed, in the format specified by ctime(3).  Then, the statistics for each
       mailer are displayed on a single line, each with the following white space separated fields:

	      M 	  The mailer number.
	      msgsfr	  Number of messages from the mailer.
	      bytes_from  Kbytes from the mailer.
	      msgsto	  Number of messages to the mailer.
	      bytes_to	  Kbytes to the mailer.
	      msgsrej	  Number of messages rejected.
	      msgsdis	  Number of messages discarded.
	      Mailer	  The name of the mailer.

       After this display, a line totaling the values for all of the mailers is displayed (preceded with a ``T''),  separated  from  the  previous
       information by a line containing only equals (``='') characters.  Another line preceded with a ``C'' lists the number of TCP connections.

       The options are as follows:

       -C     Read the specified file instead of the default sendmail configuration file.

       -c     Try to use submit.cf instead of the default sendmail configuration file.

       -f     Read the specified statistics file instead of the statistics file specified in the sendmail configuration file.

       -P     Output information in program-readable mode without clearing statistics.

       -p     Output information in program-readable mode and clear statistics.

       -o     Don't display the name of the mailer in the output.

       The mailstats utility exits 0 on success, and >0 if an error occurs.

FILES

       /etc/mail/sendmail.cf	The default sendmail configuration file.
       /etc/mail/statistics	The default sendmail statistics file.

SEE ALSO

       mailq(1), sendmail(8)

							   $Date: 2002/09/26 23:03:39 $ 					      MAILSTATS(8)
All times are GMT -4. The time now is 04:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy