Visit Our UNIX and Linux User Community


remove space


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting remove space
# 1  
Old 08-15-2012
MySQL remove space

File A.txt

Code:
A005           -119.5                -119.5                -100.5
A006           -120.5                -119.5                -119.3
A008                0                     0                     0

Output
Code:
A005     -119.5       -119.5       -100.5      
A006     -120.5       -119.5       -119.3      
A008     0            0            0

# 2  
Old 08-15-2012
I'd first look at what are white characters. Are they spaces, tabs, something else?
Code:
cat -A A.txt

or
Code:
cat A.txt | od -c

if your system doesn't support -A option.
Then
Code:
sed 's/  */    /g' A.txt

where you substitute the first two spaces with your white characters that are in the file.
//============================================
Alternatively, if you have only 4 columns, here is an awk + printf solution:
Code:
awk '{printf("%-10s%-10s%-10s%-10s\n",$1,$2,$3,$4)}'  A.txt

Change 10 to how wide you want the columns.

Previous Thread | Next Thread
Test Your Knowledge in Computers #322
Difficulty: Easy
HTML stands for Hypertext Markdown Language.
True or False?

10 More Discussions You Might Find Interesting

1. Programming

Python 3 remove the space after the last /

using python 3 when i run this code to get the urls i get a space in the url how do i remove the space after the last / thanks # Import libraries import requests from bs4 import BeautifulSoup # Connect to the URL page = requests.get('https://www.meihoski.co.jp/movie/') soup... (3 Replies)
Discussion started by: bob123
3 Replies

2. UNIX for Beginners Questions & Answers

Remove space with sed

Hello Folks , myfile contains 1000000 records as follows: logver=56 idseq=63256 itime=1111 devid=TG-40 devname=PUI-C2 vd=USER date=2019_01_10 time=18:39:49 logid="000013" type="traffic" subtype="forward" level="notice" eventtime=134 srcip=1.1.1.1 srcport=1 srcintf="XYX-CORE.01"... (3 Replies)
Discussion started by: arm
3 Replies

3. Shell Programming and Scripting

Remove space from numeric value

Hello, I need help. I have xml file and there are one extra space on number <EpiReference>1 42345</EpiReference>. And of cource, the value change on every new file. I need remove space from that value what is in between <EpiReference> and </EpiReference>. How I can do that? This are example... (9 Replies)
Discussion started by: Jopsulainen
9 Replies

4. UNIX for Advanced & Expert Users

Need to remove leading space from awk statement space from calculation

I created a awk state to calculate the number of success however when the query runs it has a leading zero. Any ideas on how to remove the leading zero from the calculation? Here is my query: cat myfile.log | grep | awk '{print $2,$3,$7,$11,$15,$19,$23,$27,$31,$35($19/$15*100)}' 02:00:00... (1 Reply)
Discussion started by: bizomb
1 Replies

5. Shell Programming and Scripting

remove space of each line

Hi Guys, I want remove starting space of each line ... My Input: A B C D E C V F G H F R T Y U D F G H J L O I U Y G P O K O P L O L O I P P O P P P P P My Output: A B C D E C V F G H (7 Replies)
Discussion started by: asavaliya
7 Replies

6. Shell Programming and Scripting

Remove last space in a string?

I have a customer file now and would like to separate the names into two cells in a spreadsheet. Here is my data as an example: SHAWN R KEEGAN shawn r scroggin Shawn Regan Shawn Reilly The first two have the middle initial so I'd like to include them in the "first name" field and the last... (11 Replies)
Discussion started by: Grassy
11 Replies

7. Shell Programming and Scripting

Remove space

DATE=6/Jul/2010 6/Jul/2010 var="sed -n '/\ ---------- Post updated at 11:49 AM ---------- Previous update was at 11:36 AM ---------- #!/bin/bash DATE=`./get_date.pl 3` DATE1=`./get_date.pl 2` var1=$( echo "$DATE" | sed "s/ //g" ) var2=$( echo "$DATE1" | sed "s/ //g" ) var="sed -n... (1 Reply)
Discussion started by: sandy1028
1 Replies

8. UNIX for Dummies Questions & Answers

Space in file how to remove

Hello I have a file with data something like this in it : texttexttext "text .lst" TEXT=" text " texttexttext "moretext .lst" TEXT=" text " Question is how do I get rid of space so that the files looks like this : texttexttext "text.lst" TEXT="text" texttexttext... (8 Replies)
Discussion started by: davebw
8 Replies

9. Shell Programming and Scripting

How to remove space in between the result

Hi All, How do i remove the spaces in between, the outputted result: my output is like below and i dont want spaces between them, how do i do that. I am enclosing the peice of code that does that:- if ; then $ECHO "The Path is:" $OFFERING_FILE_PATH/$z $ECHO $Z else $ECHO "" fi... (10 Replies)
Discussion started by: asirohi
10 Replies

10. Shell Programming and Scripting

remove space characters

hello I have this output ifspeed 100000000 ifspeed 100000000 collisions 413 collisions 10 duplex full duplex ... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

Featured Tech Videos