Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sed query

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed query
# 8  
Old 12-08-2006
try this
Code:
sed "/^Debit Amount:/ s/\(.\{27\}\)\(....\)\(.*\)/\1\3\\
XXXXXXXXXXXXXXXXXXXXXXXXXXXX\2\3/" b $file > tmp

# 9  
Old 12-08-2006
sed solution
Thats great thanks anbu
Just one last thing....
The currency code at the end of line 5 remains.


Can we get rid of it from this line ?
Many thanks
# 10  
Old 12-11-2006
Quote:
Originally Posted by grinder182533
Thats great thanks anbu
Just one last thing....
The currency code at the end of line 5 remains.


Can we get rid of it from this line ?
Many thanks
I used your input and got the following output. I dont find the problem what you said.

Code:
Ref: 12345678^M
Value Date: 28-MAY-2006^M
Debit A/c: 54321235 - abcdef^M
Customer : 100210547 - abcdef^M
Debit Amount: 9999999999.00^M
XXXXXXXXXXXXXXXXXXXXXXXXXXXX USD^M
Description: wire to Wxxxxxx^M
^M
Exchange Rate: 1.00000^M

Code:
sed "/^Debit Amount:/ s/\(.\{27\}\)\(....\)\(.*\)/\1\3\\
XXXXXXXXXXXXXXXXXXXXXXXXXXXX\2\3/" b $file > tmp

Change number 27 to length from the start of line till blank space between number and currency code
# 11  
Old 12-11-2006
sed etc
I guess I must have mistyped.
I'll retry.
Many thanks
# 12  
Old 12-11-2006
Power sed etc
Hi anbu
It is the b argument which is not liked :

sed: 0602-419 Cannot find or open file b.

I am running with AIX Version 4
man sed
sed Command
Purpose
Provides a stream editor.
Syntax
sed [ -n ] Script [ File ... ]
sed [ -n ] [ -e Script ] ... [ -f ScriptFile ] ... [ File ... ]
# 13  
Old 12-12-2006
Use this
Code:
sed "/^Debit Amount:/ s/\(.\{27\}\)\(....\)\(.*\)/\1\3\\
XXXXXXXXXXXXXXXXXXXXXXXXXXXX\2\3/" $file > tmp

# 14  
Old 12-12-2006
sed etc
I did thanks anbu23, but then got the last 3 characters on the right on line 5 remaining, as previously illustrated.
I could always add a 2nd sed command to strip off the last 3 characters
of line 5, I suppose ?
Not very scientific, but it would work.

Thanks for your continuing support.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed for query

Hi all, I am trying to remove quite a lot of numbers for a file I have which looks something along the lines of; 1,2,3,4,5,6 etc I have a list of numbers I want removing looking like; 10000 10987 16572 etc etc and have been trying to run; for id in `cat list` ; do sed -i -e... (8 Replies)
Discussion started by: JayC89
8 Replies

2. Shell Programming and Scripting

SED Query

Hi all, I am trying to use SED to input lines to a file in a specific place. So far I have; sed '/#NewEntry/ i\Insert this line' myfile.txt The output is printing to screen correctly but what is the best way to write it back to the file without overwriting everything? I tried adding >... (6 Replies)
Discussion started by: JayC89
6 Replies

3. OS X (Apple)

Sed query

Hello Im fairly familiar with using the sed command for substitution, however I have been passed a script which checks the logged on username and directory type with a sed section which I cant figure out. The sed function has me baffled and I cant find out from the man page what its trying to do... (1 Reply)
Discussion started by: costaanglais
1 Replies

4. Shell Programming and Scripting

sed query

I have a sed query. There is a line which has tilde and I want to separate this line using sed. The line is: ABP_ETC_ROOT=~xdmadm The query to get this line is: sed -n '/\(.*\)~\(.*\)/p' infile I want to get xdmadm from this line and I am using this sed command: sed -n... (5 Replies)
Discussion started by: som.nitk
5 Replies

5. Shell Programming and Scripting

sed query

hi i had posted this earlier.. got no reply !! how to change assigned value in a file using sed suppose the file contains age = 30; how to change it to age =50; i tried sed 's/^age*./age =50;' filename but i am getting the o/p as age =50; 30; plz hlp!! (4 Replies)
Discussion started by: gopsman
4 Replies

6. Shell Programming and Scripting

query on sed

I have done a script using sed which replaces a string in file. I face 2 problems, while using sed command. 1)last line of the file is missing. 2)if i am are using wild card character in the command, Its not taking the next matching pattern ie if I am giving the pattern abc*def to be replaced... (2 Replies)
Discussion started by: iceiceice
2 Replies

7. UNIX for Dummies Questions & Answers

Reg: Query in sed

Hi Penchal, I would appreciate if you can provide me a brief explanation on what you are trying to do in the commnad below. echo "6-9-2008" | sed 's/\(.\)-\(.\)-\(.*\)/\3-0\2-0\1/g' Thanks Amit (1 Reply)
Discussion started by: patelamit009
1 Replies

8. Shell Programming and Scripting

sed related query

Hi I have a file which looks like this //string = "abcd"; //info //string = "*pqrs"; //add string = "#123"; //sub //string = "#1234567890" data = check(string) //string = "#1234567890" I want to modify this as string = "#987"; //mult data = check(string) How do i do that? (1 Reply)
Discussion started by: gopsman
1 Replies

9. Shell Programming and Scripting

SED query

I'm writing a script which word counts the number of lines in two files. If one file is bigger than the other I'd like to edit one of the files to delete some lines to make both the same. It does not matter where in the file the lines are deleted from. It's expected that this will be ran from... (3 Replies)
Discussion started by: chog1010
3 Replies

10. Shell Programming and Scripting

sed query..

hi, I have an xml file and I need to replace the tags with different names all at a time here is what I have <cevalue> <cevalue1> <cevalue2> <cevalue3> <cevalue4> <cevalue5> and I need these like these... <cevalue> <cevalue> <cevalue> <cevalue> <cevalue> <cevalue> I tried a few but... (2 Replies)
Discussion started by: mgirinath
2 Replies
Login or Register to Ask a Question