08-09-2007
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 filename|tr -s ""
my problem doesnot solve.I am getting leading spaces before the date.
I need an output like: 2007-06-30 00:00:00
Can anybody help me??
-- Mahek
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
Hi,
I am trying to remove trailing white spaces using this command in awk
nawk -F '|' '/^TR/{t = $4 }/^LN/{gsub(/ */,"");printf "%s|%s\n", t, $0 }' $i>>catman_852_files.txt
My delimiter is '|'.
THere are some description fields which are being truncated. I dont want to remove spaces... (1 Reply)
Discussion started by: kiran_418
1 Replies
3. Shell Programming and Scripting
I want to remove the trailing spaces from any line of file.
line ending does not follow any pattern.
plz help (3 Replies)
Discussion started by: vikas_kesarwani
3 Replies
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
I am getting a value from a csv file using CUT command, however the command extracting the records with trailing spaces. I am using the result into a sql session to fetch data, because of the trailing spaces the sql session is unable to fetch any data.
Please let me know, how to remove this... (2 Replies)
Discussion started by: mady135
2 Replies
7. Shell Programming and Scripting
HI,
I need the help from the experts like I have created one file with text like:
a b c d
e f g h
i j k l
So my question is that i have to write the script in which like in the first sentence it will take only one space after d and remove all the extra space in the end.I dont... (8 Replies)
Discussion started by: bhanudhingra
8 Replies
8. Shell Programming and Scripting
Platform: Oracle Linux 6.5
I have a file with hundreds of values enclosed in single quotes like below. I want the trailing empty spaces before the ending quote to be removed. Expected output shown below. Can this be done using good old vi editor ? Or should I use sed or awk for this ?
$ cat... (4 Replies)
Discussion started by: kraljic
4 Replies
9. Shell Programming and Scripting
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.
07/12/2017 15:55:00 |entinfdev |AD ping Time ms | .474| 1.41| .581|green |flat... (9 Replies)
Discussion started by: svajhala
9 Replies
10. Shell Programming and Scripting
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
conjunct
CONJUNCT(1) General Commands Manual CONJUNCT(1)
NAME
conjunct - find dates of equinox or new or full moon
SYNOPSIS
conjunct [options]
DESCRIPTION
conjunct searches for one of these events: spring equinox (default), summer solstice, autumn equinox, winter solstice, new moon, or full
moon.
OPTIONS
-s, --start date
Set starting date (default is current date). The date may be either a Julian day number (e.g. 2454180.0 for noon, 2007 March 20) or
an ISO 8601 date (e.g. 2007-03-20).
-e, --end date
Set ending date (default is one year from now).
-V, --vernal, --spring
Search for spring equinox (default).
-S, --summer
Search for summer solstice.
-A, --autumn, --fall
Search for autumn equinox.
-W, --winter
Search for winter solstice.
-N, --newmoon
Search for new moon.
-F, --fullmoon
Search for full moon.
-h, --help
Show summary of options.
SEE ALSO
aa(1).
AUTHOR
conjunct was written by Stephen L. Moshier <steve@moshier.net>.
This manual page was written by James R. Van Zandt <jrv@debian.org>, for the Debian project (but may be used by others).
August 24, 2006 CONJUNCT(1)