Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove the characters from the file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove the characters from the file
# 1  
Old 02-10-2010
Remove the characters from the file
Hi,

I have one file in the following format.

Code:
exa_resu_adj.4ge v.47645 PERSONAL INFORMAIONS PVT LTD 31 Dec 2009 04:36 Page 1
 
SALARY REPORT
Account Account Name CCode Bill No Balance T Amt
----------- ------------ ------- ---------- ------------- -------------
17490001 Mr Ram PM 10 1000.00 -1000.00
17490006 Mr Dom AM 10 1000.00 -1000.00
17490003 Mis Pr PM 10 1000.00 -1000.00
-------------
TOTAL : -3000.00
-------------
NUMBER : 3
-------------
-------------
REPORT TOTAL : -3000.00
-------------
TOTAL NUMBER: 3
End of Report Requested by: kattoor

Here I need to remove the following fields
Code:
exa_resu_adj.4g3 v.47645
and 
End of Report Requested by: kattoor

Can anybody help me out..?

Thanks in advance..!!
Last edited by zaxxon; 02-10-2010 at 04:07 AM.. Reason: use code tags please, ty
# 2  
Old 02-10-2010
Code:
grep -v -e 'exa_resu_adj.4g3 v.47645' -e 'End of Report Requested by: kattoor' "$file"

# 3  
Old 02-10-2010
Or:
Code:
awk 'NR>1 && !/^End of Report/' file

# 4  
Old 02-10-2010
Code:
sed -e '/exa_resu_adj.*/d' -e '/End of Report.*/d' file

Be interesting to know which is quicker ?

---edit---

Not much in it :-

Code:
xxx@xxx$ time awk 'NR>1 && !/^End of Report/' test >/dev/null

real    0m0.016s
user    0m0.000s
sys     0m0.010s
xxx@xxx$
xxx@xxx$
xxx@xxx$ time sed -e '/exa_resu_adj.*/d' -e '/End of Report.*/d' test >/dev/null

real    0m0.014s
user    0m0.000s
sys     0m0.010s
xxx@xxx$
xxx@xxx$ time /usr/xpg4/bin/grep -v -e 'exa_resu_adj.4g3 v.47645' -e 'End of Report Requested by: kattoor' test >/dev/null

real    0m0.013s
user    0m0.000s
sys     0m0.010s
xxx@xxx$

Last edited by lavascript; 02-10-2010 at 01:11 PM..
# 5  
Old 02-16-2010
Thanks for your quick response..!

Here I am facing some more issues in the first line of the file.

I just want to delete the word 'exa_resu_adj.4g3 v.47645' from the first line, the remaining words I need whatever it is.

If am using the above mentioned commands, its removing the entire line itself.

Can anybody help me out on this...?
# 6  
Old 02-16-2010
Try this.

Code:
sed 's/exa_resu_adj.4ge v.47645//g' $filename | sed 's/End of Report Requested by: kattoor//g'

# 7  
Old 02-16-2010
Thanks alot....Its working....!!Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove non printing characters from file

How do I remove the printer escape sequence, the first 5 characters, that occurs on every 33rd line in a file, see hex dump of line 1. 0000 1e 00 00 00 00 0a 0a 0a 20 0a 20 20 20 20 20 20 .... 0010 20 20 20 20 20 20 20 20 20 20 0a 42 49 4c 4c 20 Thanks, (2 Replies)
Discussion started by: jgt
2 Replies

2. Shell Programming and Scripting

Remove characters from the file

i know , the below question has been repeated. can you guys guide me . I have the below input 999999 xxxxxxxxxxxxxx 123.45 2013-05-02 08:14 1 1 1 xxxx 999999 xxxxxxxxxxxxxx 123.45 2013-06-02 02:14 1 4 1 dddd i need to remove from the column 54 to 70 , as like the below output.... (9 Replies)
Discussion started by: expert
9 Replies

3. Shell Programming and Scripting

how to remove the non : characters after the password in shadow file?

On SPARC Solaris 10. I set the app account so it's expired. I also want it so not required to change password at first login, I can do this by removing the numbers after the password in /etc/shadow. example using user1 The /etc/shadow file looks like this: user1:kOmcVXAImRTAY:0::::90:: ... (8 Replies)
Discussion started by: TKD
8 Replies

4. Shell Programming and Scripting

Remove characters from fixed length file

Hello I've question on the requirement I am working on. We are getting a fixed length file with "33" characters long. We are processing that file loading into DB. Now some times we are getting a file with "35" characters long. In this case I have to remove two characters (in 22,23... (14 Replies)
Discussion started by: manasvi24
14 Replies

5. UNIX Desktop Questions & Answers

Remove new line characters from a file

I tried using below command tr -cd "" < InputFile.xml > output.txt ============= This removes all the tabs/newline/extra spaces from a file it successfully removed all the extra spaces,tabs and new line characters but then the complete file become one record. I want to retain one new line... (1 Reply)
Discussion started by: saini
1 Replies

6. Shell Programming and Scripting

How to remove ^M characters from a zip file?

Hi All, As all of us know that while moving a file from Windows to Unix some unwanted ^M characters appear in the file. For my case I have release package in zip format which looks like Module_Name_Tag.zip. It contains some directory structure...like Module_Name_Tag.zip | |--trunk/... (2 Replies)
Discussion started by: bhaskar_m
2 Replies

7. Shell Programming and Scripting

Trying to remove '^M' characters from a file.

Hi guys, Hope you are all well. This is a line of data from a csv file. I have used vi and set the 'set list' option to display the trailing $ character. "01","Grocery","01006","eat Fish & Spreads"$ I have tried the following commands, but neither of them appear to be working? 1) tr... (13 Replies)
Discussion started by: Krispy
13 Replies

8. Shell Programming and Scripting

Remove characters from file name

Here is my code. for file in *1.3.html ; do mv "$file" `echo $file | tr '.1.3' ''` ; done For some reason I am getting an error. mv: file.idlesince.1.3.html and file.idlesince.1.3.html are identical Could this be done a different way? (5 Replies)
Discussion started by: mrlayance
5 Replies

9. Shell Programming and Scripting

sed to remove last 2 characters of txt file

sed 's/^..//' file1.txt > file2.txt this will remove the first two characters of each line of a text file, what sed command will remove the last two characters? This is a similar post to my other....sry if I'm being lazy.... I need a file like this (same as last post) >cat file1.txt 10081551... (1 Reply)
Discussion started by: ajp7701
1 Replies

10. UNIX for Dummies Questions & Answers

How to remove null characters from file?

I'm trying to remove the null characters from a file and copy it to std output. I'm using emacs and I create the following one line bash file (followed by the error messages): sed -e 's/^@//' <ConfigItemReplicator.install.log /usr/bin/bash: -c: line 0: unexpected EOF while looking for... (1 Reply)
Discussion started by: siegfried
1 Replies
Login or Register to Ask a Question