Remove of white space when you have multiple column Post: 302978658

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

stripping white space...

Hi All; Having a problem with a file.. the file contains the following data... (a snapshot) 1331F9E9DB7C2BB80EAEDE3A8F043B94,AL7 1DZ,M,50 186FDF93E1303DBA217279EC3671EA91,NG5 1JU,M,24 3783FFAF602015056A8CD21104B1AAAF,CH42 4NQ,M,17 It has 3 columns sepreated by a , the second column...

2. Shell Programming and Scripting

remove first column of a space delimited txt

how to remove the first column of a space delimited txt file? there are 12+ columns... what is the cleanest way? could use awk and print all but the first, but it looks kinda ugly awk '{print $2" "$3" "$4" "$5" "$6" "$7" "$8" "$9" "$10" "$11" "$12"}' file.txt whats a better way?

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

5. Shell Programming and Scripting

sed + white space

Hi, What sed command (if sed is the right command) can remove ALL white space from my file. I have a csv, except I want to remove all white space between commas and characters. My idea (without testing) sed 's/ //g' Is there a better way?

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

7. Shell Programming and Scripting

Remove unwanted white space

Hi, I have a very big file 25GB with information present in it like $ head ind_stats update index statistics pfirm001.dbo.Office using 200 values go ...

8. Shell Programming and Scripting

how to remove tab space only in the column of a specific row

Hi, I need help to remove tab delimited space in the $2 of a specific row. My file is like this:- file1.txt No_1 4 139 156 No_1 5 161 205 No_4 91 227 212 No_19 254 243 263 No_19 645 249 258 No_19 101 2492 2635 No_90 8 277 288...

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

10. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

How to change the uploaded weekly file data to the following format? New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi. BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430 BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430...

LEARN ABOUT OSX

neaten

NEATEN(1)						      General Commands Manual							 NEATEN(1)

NAME

       neaten - neaten up output columns

SYNOPSIS

       neaten [ format ]

DESCRIPTION

       Neaten  reads  from  its standard input and neatens up columns separated by white space using the specified format.  The format is a string
       consisting of a positive integer followed by an alignment character and another integer.  The alignment	character  is  usually	a  decimal
       point ('.'), but it can be any non-digit.

       The  alignment  character  is used as the central point of each column.	The total column field width will be the number to the left of the
       alignment character plus one for the alignment character itself plus the number to the right of the alignment character.

       If a field does not contain the alignment character, it will be printed to the left of where the alignment character would  have  appeared.
       If  a  field  is  too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
       rest.

       The default format is "8.8".

EXAMPLE

       To examine a file with columns of numbers:

	 neaten 10.8 < input | more

BUGS

       Columns wider than the total width of the format specification will be printed without any separating white space.

       The program does not do anything special with tabs on the input.

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), rcalc(1), rlam(1), total(1)

RADIANCE
							     11/15/93								 NEATEN(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

stripping white space...

Discussion started by: Zak

2. Shell Programming and Scripting

remove first column of a space delimited txt

Discussion started by: ajp7701

3. Shell Programming and Scripting

Remove white space at the beginning of lines

Discussion started by: tipi

4. UNIX for Dummies Questions & Answers

SED with White Space

Discussion started by: sandeep_1105