03-24-2006
removing spaces after sperator
Hi friends
i have problem
6000000001| CDC049| 109| CDC| 02/02/2006| Auto| New Add| 02/03/2006
6000000002| CDC033| 109| CDC| 02/02/2006| Auto| New Add| 02/03/2006
6000000003| CDC037| 109| CDC| 02/02/2006| Auto| New Add| 02/03/2006
6000000004| CDC031| 109| CDC| 02/02/2006| Auto| New Add| 02/03/2006
6000000005| CDC023| 109| CDC| 02/02/2006| Auto| New Add| 02/03/2006
6000000006| CDC034| 109| CDC| 02/02/2006| Auto| New Add| 02/03/2006
but i want the file to be in the following format
6000000001|CDC049|109|CDC|02/02/2006|Auto|New Add|02/03/2006
6000000002|CDC033|109|CDC|02/02/2006|Auto|New Add|02/03/2006
6000000003|CDC037|109|CDC|02/02/2006|Auto|New Add|02/03/2006
6000000004|CDC031|109|CDC|02/02/2006|Auto|New Add|02/03/2006
6000000005|CDC023|109|CDC|02/02/2006|Auto|New Add|02/03/2006
6000000006|CDC034|109|CDC|02/02/2006|Auto|New Add|02/03/2006
with out any space character after separator after |
The spaces can be one tab or just one space or both
hope some can help me
thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have output a file and need to remove blank spaces in the first lines only so the file is left end justified. I need to do this while keeping the rest of the file intact.
Example of file that needs spaces removed:
space
space space
space space space
space... (3 Replies)
Discussion started by: tioray
3 Replies
2. UNIX for Dummies Questions & Answers
I stored results like this
VAR=`wc -l < ls.txt`
But the value of the wc gave me a padded number.
How do I strip the padding from $VAR?
Do you think I could use SED?
Except instead of a file input, have a variable redirection input? (2 Replies)
Discussion started by: yongho
2 Replies
3. Shell Programming and Scripting
I have a file with delimiter ~
ABC~12~43~TR ~890~poi~YU ~56~65
What I want is to remove spaces from column 4,7 and other columns as it is
So, the final file becomes
ABC~12~43~TR~890~poi~YU~56~65 (7 Replies)
Discussion started by: superprogrammer
7 Replies
4. Shell Programming and Scripting
hey..
i had a problem with the unix command when i want to remove the white spaces in a string..i guess i cud do it with a sed command but i get an error when i give space in the square brackets..
string="nh hjh llk"
p=`echo $string | sed 's/ //g'`
i donno how to give space charater and... (2 Replies)
Discussion started by: sahithi_khushi
2 Replies
5. UNIX for Dummies Questions & Answers
Hey,
I'm using the command from this thread https://www.unix.com/unix-dummies-questions-answers/590-converting-list-into-line.html
to convert vertical lines to horzontal lines. But I need to remove the spaces that is created. Unfortunately I can't figure out where the space is in the code..
I... (2 Replies)
Discussion started by: lost
2 Replies
6. Shell Programming and Scripting
Hi,
I want to remove spaces from data.
Data is:
1,aa ,21, 22
2,a a ,23 ,24
3, ,25 ,26
output should be:
1,aa,21,22
2,a a,23,24
3, ,25,26
i.e
i have to remove leading and trailing spaces.Not the space between data and also i dont want to remove the space if data is... (4 Replies)
Discussion started by: monika
4 Replies
7. Shell Programming and Scripting
Hello All,
I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out.
My file is like this (<b> means one blank space, <t> means one tab space)-
$ cat file
NARESH<b><b><b>KUMAR<t><t>PRADHAN... (3 Replies)
Discussion started by: NARESH1302
3 Replies
8. Shell Programming and Scripting
Hello,
I have a Folder (myfile) which contain the following files:
P$12789865KR +N+01+OM+16102009165416.nu
P$M1-508962GD +N+01+ALP+14102009094417.nu
Is there a sed command(s) that will loop through this folder
and remove the spaces that exists in the filename?
Any help would be... (7 Replies)
Discussion started by: Fishn
7 Replies
9. Shell Programming and Scripting
HI,
I have a file with lot of blank lines, how can I remove those using awk??
Thanks,
Shruthi (4 Replies)
Discussion started by: shruthidwh
4 Replies
10. Shell Programming and Scripting
I have pipe separated file with lots of blank spaces.
After using sed -e 's/ *| */|/g' this command ,its giving me output as
TT0000013101640|
HCAMBLAMCNB010|Jul 3 2012 11:14AM|
HARYANA|
Bangali Mohalla |
TCL-UBR|9368040005|9355264655|9218509220|NULL
... (5 Replies)
Discussion started by: sususa
5 Replies
LEARN ABOUT DEBIAN
lr_environment
LR_ENVIRONMENT.IN(1) LogReport's Lire Documentation LR_ENVIRONMENT.IN(1)
NAME
lr_environment - Export Lire configuration in shell script form
SYNOPSIS
eval `lr_environment`
DESCRIPTION
The lr_environment command is used to import the Lire configuration in Lire shell scripts.
All of Lire configuration variables will be written in a format that can be evaled by the shell.
Shell scripts don't usually have to use that command, since it is done by the defaults file sourced by each command.
The old names used by when the configuration was done in shell script are also exported by this script for backward compatibility.
AUTHOR
Francis J. Lacoste <flacoste@logreport.org>
VERSION
$Id: lr_environment.in,v 1.12 2006/07/23 13:16:33 vanbaal Exp $
COPYRIGHT
Copyright (C) 2003 Stichting LogReport Foundation LogReport@LogReport.org
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
Lire 2.1.1 2006-07-23 LR_ENVIRONMENT.IN(1)