Removing spaces between records


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Removing spaces between records
# 1  
Old 04-29-2005
Removing spaces between records

Hi I have an XML file. Which has spaces between different records....

current file( Has many lines, like this... I want to delete all the spaces between > and <, if there are only spaces between them)

input file
<xyzr> <abc>1234</xyzr> <aaa> <bbb> ayz mnz</bbb> <sen>KEA EP</sen> <LAN>aa</LAN>


My output should look like (in a single line)
<xyzr><abc>1234</xyzr><aaa><bbb> ayz mnz</bbb><sen>KEA EP </sen> <LAN>aa</LAN>

Can some one help me out, how I can achieve this....
# 2  
Old 04-29-2005
Try:
sed 's/> *</></g' < inputfile > outputfile
# 3  
Old 04-29-2005
Iam on sun solaris....
sed 's/> *</></g' a1.t >a2.t is not working...
I tried the above command in different ways

sed 's/\> *\</\>\</g' a1.t >a2.t

sed 's/\> \</\>\</g' a1.t >a2.t

None of them are working.... a2.t is created with 0 bytes...
# 4  
Old 04-29-2005
Well, here's an idea...try it the way I wrote it...
Code:
$ cat a1.t
<xyzr> <abc>1234</xyzr> <aaa> <bbb> ayz mnz</bbb> <sen>KEA EP</sen> <LAN>aa</LAN>

$ sed 's/> *</></g' < a1.t > a2.t
$ cat a2.t
<xyzr><abc>1234</xyzr><aaa><bbb> ayz mnz</bbb><sen>KEA EP</sen><LAN>aa</LAN>

$ uname -a
SunOS dev 5.6 Generic_105181-28 sun4d sparc SUNW,SPARCserver-1000
$

But also, your first modification looks like it should work....
Code:
$ rm a2.t
$ sed 's/> *</></g' a1.t >a2.t
$ cat a2.t
<xyzr><abc>1234</xyzr><aaa><bbb> ayz mnz</bbb><sen>KEA EP</sen><LAN>aa</LAN>

$

And it does for me.
# 5  
Old 04-29-2005
There looks to be some tabs , null characters in between, I suppose...
They are not only spaces... Anyway to get rid of them
# 6  
Old 04-29-2005
If it's just tab's it's easy. Except that you must actually type a tab character in the command and that won't show up here. I'll use TAB to indicate a tab character.
Code:
 sed 's/>[ TAB]*</></g' < a1.t > a2.t

# 7  
Old 11-17-2005
How do I get a tab character?
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing spaces between parenthesis ()

Hello, i 've go a file with the following text: oracle@das (J005) 0 oracle@das (J008) 0 oracle@das (J050) 0 oracle@das (J038) ... (15 Replies)
Discussion started by: nms
15 Replies

2. Shell Programming and Scripting

Removing non matching records

Hi all I have a file with records starting with "Page" has a first column. some of the records have some other junk characters has first column. so pls help me to remove rows which is not having "Page" has a first column. Thanks, Baski (2 Replies)
Discussion started by: baskivs
2 Replies

3. Shell Programming and Scripting

Removing duplicate records from 2 files

Can anyone help me to removing duplicate records from 2 separate files in UNIX? Please find the sample records for both the files cat Monday.dat 3FAHP0JA1AR319226MOHMED ATEK 966504453742 SAU2010DE 3LNHL2GC6AR636361HEA DEUK CHOI 821057314531 KOR2010LE 3MEHM0JG7AR652083MUTLAB NAL-NAFISAH... (4 Replies)
Discussion started by: zooby
4 Replies

4. Shell Programming and Scripting

Removing spaces from record

HI i have record as shown below 402665,4X75,754X_FERNIE BC,12F2,008708,FERNIE BC,1,UTC ,UTC ,250 402665,4X75,754X_FERNIE BC,F212,008708,FERNIE BC,1,UTC ,UTC ,250 402665,4Y75,754Y_FERNIE BC,22F2,008708,FERNIE BC,1,UTC ,UTC ,250 here i want to remove multiple spaces into no... (3 Replies)
Discussion started by: raghavendra.cse
3 Replies

5. 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

6. Shell Programming and Scripting

Removing spaces in a line

Hi All, I have a line like this " field1;field2;field3 " (single space after and before double quotes). Now i have to remove these single space . Kindly help me. Thanks in advance (2 Replies)
Discussion started by: krishna_gnv
2 Replies

7. 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

8. 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

9. 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

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