04-09-2010
Thank you for your replies! I was able to do workaround on my sql. Instead of fixing the file, I took out the spaces on my sql results and it worked perfectly.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a text file which is not fixed width. I want to put trailing spaces to each line and make it a 100 byte fixed width file.
Can someone please help me as soon as possible?
Thanks,
Denis (1 Reply)
Discussion started by: 222001459
1 Replies
2. UNIX for Dummies Questions & Answers
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
3. 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
4. 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
5. 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
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
ECHO(1) FSF ECHO(1)
NAME
echo - display a line of text
SYNOPSIS
echo [OPTION]... [STRING]...
DESCRIPTION
NOTE: your shell may have its own version of echo which will supercede the version described here. Please refer to your shell's documenta-
tion for details about the options it supports.
Echo the STRING(s) to standard output.
-n do not output the trailing newline
-e enable interpretation of the backslash-escaped characters listed below
-E disable interpretation of those sequences in STRINGs
--help display this help and exit
--version
output version information and exit
Without -E, the following sequences are recognized and interpolated:
NNN the character whose ASCII code is NNN (octal)
\ backslash
a alert (BEL)
backspace
c suppress trailing newline
f form feed
new line
carriage return
horizontal tab
v vertical tab
AUTHOR
Written by FIXME unknown.
REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>.
COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
The full documentation for echo is maintained as a Texinfo manual. If the info and echo programs are properly installed at your site, the
command
info echo
should give you access to the complete manual.
GNU coreutils 4.5.3 February 2003 ECHO(1)