Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Remove leading and trailing spaces from a file
Top Forums Shell Programming and Scripting Remove leading and trailing spaces from a file Post 303000470 by svajhala on Wednesday 12th of July 2017 04:51:58 PM
Old 07-12-2017
Remove leading and trailing spaces from a file
Hi,

I am trying to remove leading and trailing spaces from a file using awk but somehow I have not been able to do it.

Here is the data that I want to trim.

Code:
07/12/2017 15:55:00               |entinfdev        |AD ping Time ms          |      .474|      1.41|      .581|green        |flat
07/12/2017 15:55:00              |entinfdev                         |CPU Busy%             |         1|         2|         1|green      |flat
07/12/2017 15:55:00        |entinfdev            |Collected at                |1499888700|1499889000|1499889300|grey        |flat
07/12/2017 15:55:00      |entinfdev     |FS /tmp Used%             |         1|         1|         1|green  |flat
07/12/2017 15:55:00 |entinfdev    |FS /var/tmp Used%            |        74|        74|        74|orange    |flat

And I want the data to be looked like this.

Code:
07/12/2017 15:55:00|entinfdev|AD ping Time ms|.474|1.41|.581|green|flat
07/12/2017 15:55:00|entinfdev|CPU Busy%|1|2|1|green|flat
07/12/2017 15:55:00|entinfdev|Collected at|1499888700|1499889000|1499889300|grey|flat
07/12/2017 15:55:00|entinfdev|FS /tmp Used%|1|1|1|green|flat
07/12/2017 15:55:00|entinfdev|FS /var/tmp Used%|74|74|74|orange|flat

Please let me know if there a better way to do it.

Thank you.
Last edited by svajhala; 07-12-2017 at 06:31 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Leading and Trailing Spaces

Hi, how to i remove leading and trailing spaces from a line? the spaces can be behind or in front of any field or line example of a line in the input data: Amy Reds , 100 , /bin/sh how to i get it to be: Amy Read,100,/bin/sh i saw something on this on the Man pages for AWK... (7 Replies)
Discussion started by: sleepster
7 Replies

2. Shell Programming and Scripting

Strip leading and trailing spaces only in a shell variable with embedded spaces

I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help. echo $SH_VAR | command_line Syntax. The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
Discussion started by: jerardfjay
6 Replies

3. UNIX for Dummies Questions & Answers

Removing leading and trailing spaces of data between the tags in xml.

I am having xml document as below. <transactionid> 00 </transactionid> <tracknumber> 0 </tracknumber> <key> N/A </key> But the data contains leading and trailing spaces between the tags. Please let me know how can i remove these leading and trailing spaces between the tags.... (2 Replies)
Discussion started by: jhmr7
2 Replies

4. UNIX for Dummies Questions & Answers

How to remove trailing spaces

Hi, I have a file like this (ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa ------------------------------------------------------------ 2007-06-30 00:00:00 I have a requirement where i need just the date. When i do: tail -1... (2 Replies)
Discussion started by: mahek_bedi
2 Replies

5. Shell Programming and Scripting

remove trailing and leading spaces using tr command

Dear All, can you please advice how do i remove trailing and leading spaces from a pipe-delimited file using "tr" command the below cmd, i tried removed all spaces tr -d ' '<s1.txt>s2.txt1 Many thx Suresh (5 Replies)
Discussion started by: sureshg_sampat
5 Replies

6. Shell Programming and Scripting

Removing leading and trailing spaces only in PERL

Hi All, I have a file with the following contents with multiple lines 172445957| 000005911|8| 400 Peninsula Ave.#1551 | And,K |935172445957|000005911 607573888 |000098536 | 2|Ane, B |J |Ane |1868 |19861206|20090106|20071001 I want to trim the "leading and trailing spaces only" from... (2 Replies)
Discussion started by: kumar04
2 Replies

7. Shell Programming and Scripting

Remove trailing spaces from file

I'm currently writing my sql results to a file and they have trailing spaces after each field. I want to get rid of these spaces and I'm using this code: TVXTEMP=$(echo $TVXTEMP|sed -e 's/\ //g') It doesn't work though. I'm not familiar with sedscript, and the other codes I've found online... (6 Replies)
Discussion started by: avillanueva
6 Replies

8. OS X (Apple)

Remove leading spaces from file names and folders

Hi All, I have a vexing issue with leading spaces in file names. Basically, we're moving tons of data from our ancient afp file share to Box.com and Box forbids leading spaces in files or folders. The HFS file system seems to be perfectly fine with this, but almost all other Unix file systems... (1 Reply)
Discussion started by: prometheon123
1 Replies

9. Shell Programming and Scripting

Remove the leading and trailing date from a CSV file

I'm a newbie to shell scripting. Can anyone help with the below requirement ? The leading and trailing date of a files to be removed. 2017-07-12_gmr_tag_log_20170711.csv 2017-07-12_gmr_call_log_20170711.csv 2017-07-12_gmr_outgoing_log_20170711.csv I'm looking for output like... (7 Replies)
Discussion started by: shivamayam
7 Replies

10. Shell Programming and Scripting

How to remove leading and trailing spaces for variable in shell script?

Hi I have variable named tablename. The value to tablename variable has leading and trailing white spaces. How to remove the leading and training white spaces and write the value of the tablename without space to a file using shell script. ( for e.g. tablename= yyy ) INPUT ... (10 Replies)
Discussion started by: pottic
10 Replies

LEARN ABOUT DEBIAN

xen-update-image

XEN-UPDATE-IMAGE(8)					 Perl Programmers Reference Guide				       XEN-UPDATE-IMAGE(8)

NAME

       xen-update-image - Update the software installed upon offline Xen images.

SYNOPSIS

	 xen-update-image [options] imageName1 imageName2 .. imageNameN

	 Help Options:
	  --help      Show this scripts help information.
	  --manual    Read this scripts manual.
	  --version   Show the version number and exit.

	 General Options:
	  --dir       Specify the directory which contains the image(s).
	  --lvm       Specify the LVM volume group which contains the image(s).
	  --evms      Specify the EVMS container which contains the image(s).

OPTIONS

       --dir Specify the directory which contains the image(s).
       --evms Specify the EVMS container which contains the image(s).
       --help Show the script help.
       --lvm Specify the LVM volume group which contains the image(s).
       --manual Read the manual.
       --version Show the version number and exit.

DESCRIPTION

	 xen-update-image is a simple script which allows you to update
	a Xen image of Debian which has been created with xen-create-image.

	 It does this by mounting the image inside a temporary directory
	then running:

	     apt-get update

	     apt-get upgrade

	 NOTE If the image is already running within Xen this will cause
	corruption otherwise it will allow you to update your image without
	booting it.

EXAMPLES

	 The following assumes there are two images which are not currently
	running.  The images are called 'test.my.flat', and 'x11.my.flat'.

	 Updating both images can be accomplished by executing:

	    xen-update-images --dir=/home/xen test.my.flat x11.my.flat

AUTHORS

	Steve Kemp, http://www.steve.org.uk/
	Axel Beckert, http://noone.org/abe/
	StA~Xphane Jourdois

LICENSE

       Copyright (c) 2005-2009 by Steve Kemp, (c) 2010 by The Xen-Tools Development Team. All rights reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  The LICENSE file contains the
       full text of the license.

4.3.1								    2012-06-30						       XEN-UPDATE-IMAGE(8)
All times are GMT -4. The time now is 06:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy