Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

removing spaces after sperator

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting removing spaces after sperator
# 1  
Old 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
# 2  
Old 03-24-2006
Code:
sed -e "s_|[ <TAB>]*_|_g" input.txt

The <TAB> is a placeholder for an actual tab. Replace it with an actual tab.
# 3  
Old 03-24-2006
do with sed
Quote:
sed 's/ //g' filename
# 4  
Old 03-24-2006
there is a bug in that,
it removes the space between New and Add

use this,
Code:
sed 's/| /|/g' data

# 5  
Old 03-24-2006
Quote:
Originally Posted by matrixmadhan
there is a bug in that,
it removes the space between New and Add

use this,
Code:
sed 's/| /|/g' data

nice observation
# 6  
Old 03-24-2006
Or this for spaces on either, or both side(s) of the delimiter
Code:
 sed -e 's/| \| |\| | /|/g' data

Non POSIX might need this
Code:
sed -e 's/| /|/g;s/ | //g;s/ |/|/g' data

Last edited by mph; 03-24-2006 at 12:21 PM..
# 7  
Old 03-24-2006
sed 's/|[ ]*/|/g' data
this will solve urs purpose
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing blanks, spaces

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

2. Shell Programming and Scripting

awk for removing spaces

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

3. Shell Programming and Scripting

Removing spaces within Filename

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

4. Shell Programming and Scripting

Removing blank spaces, tab spaces from file

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

5. Shell Programming and Scripting

Removing spaces from data

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

6. UNIX for Dummies Questions & Answers

Removing spaces...

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

7. Shell Programming and Scripting

removing spaces

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

8. Shell Programming and Scripting

Removing spaces at particular position

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

9. UNIX for Dummies Questions & Answers

removing spaces from variables?

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

10. Shell Programming and Scripting

removing spaces in a file

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
Login or Register to Ask a Question