Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Change a Char Multiple line records

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Change a Char Multiple line records
# 1  
Old 01-29-2009
Change a Char Multiple line records
Hi All i have a file that is to big for vi and is a multiple line record

3999||20090127163547796|196.46.162.250|1028|196.207.40.112|2152|00:0C:31:BB:25:5
4|00:00:0C:07:AC:06|655016000575511|05||3C65|0D029C1D|||00644B5A|||||||||||inter
net|196.46.162.250|27795034799|2|3|8|2|31|41.6.109.137|||655|001|65534|255||2009
0127163547796|0|1.1.0|||||6001|20090127164606869|41.6.109.137|51726|196.35.68.23
7|80|GET|http://www.123w/gautproperties/thumbnail34.jpg|
|www.123|OK|200|0|582|0|287|10814|Mozilla/4.0 (compatible; MSIE 7.0;
Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506)|http://www.123w
ffen.co.za/propsearch/10-featurette.swf|3.497437|0.036066||||||||||||||||||||0|1
0814||||||||6002|20090127164546424|41.6.109.137|51726|196.35.68.237|80|||||||0||
||||||0.001397|3.233089|||||||||||||||||||||||

I have highlighted the field that i need to change basically 655016000575511 needs to be 655016000575512

As i mentioned the file is to big for vi
Last edited by Franklin52; 01-29-2009 at 06:30 AM.. Reason: change url addresses
# 2  
Old 01-29-2009
Will change the pattern in the whole file. Maybe backup the file before you go trying. And next time please use [ code ] tags to display code, data, logs, etc.

Code:
sed 's/655016000575511/655016000575512/g' infile > outfile
mv outfile infile

# 3  
Old 01-29-2009
Change a Char Multiple line records
Aploogies i'm a bit new on the forums still, the only problem with that solution is that 65501 is the only constant to search for in that field
below are a few examples that i've pulled out from the file
655014100397402
655016000261245
655016100438548

Ideally

655014100397402 would change to 655014100397403
655016000261245 would change to 655016000261246
# 4  
Old 01-29-2009
So it is a rule that all these patterns increase by 1 and it is a decimal value?

Even if you are new, please use [ code ] tags to display code, data, logs, etc.
If you want I can edit your former post, edit code-tags and you open it in edit modus to see what I have inserted in your post.
# 5  
Old 01-29-2009
Change a Char Multiple line records
Not neccesarily even if i could just add 1 to the whole number it will be great
# 6  
Old 01-29-2009
If there is no rule you can use for automation, I suggest you just line up all substitutions like I stated above one after another for every pattern exchange.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Change one line to multiple

I did help some at another forum to change one line to multiple lines. var1="abc001: text goes here yyy003: text goes here uuuu004: text goes here" Running this awk, gives correct result, but its not very nice. Any idea on how to simplify it? awk '{for (i=1;i<=NF;i++) printf $i~":"?"\n"$i" ":$i"... (7 Replies)
Discussion started by: Jotne
7 Replies

2. UNIX for Dummies Questions & Answers

Want to change common line from multiple files

Hi everyone, I've a requirement to modify an existing line which is common to multiple files. I need to replace that existing line with a new line. I've almost 900 ksh files to edit in the similar fashion in the same directory. Example: Existing Line: . $HOME/.eff.env (notice the "." at the... (3 Replies)
Discussion started by: kaleem.adil
3 Replies

3. Shell Programming and Scripting

Count char, sum and change

Hello, I have some problem in counting char of word, sum and change. I'm not sure shell script can do this. Input data: Sam1 BB BB AA AA BB BB BB Sam2 BB BB AA AA AB AB AB Sam3 BB BB BB AA BB BB BB Sam4 AB AB AB AB AB AB AA Sam5 BB BB AA AA BB BB -- If I count in column 2, B is 9... (3 Replies)
Discussion started by: awil
3 Replies

4. Shell Programming and Scripting

Split records into multiple records

Hi All, I am trying to split a record into multiple records based on a value. Input.txt "A",1,0,10 "B",2,0,10,15,20 "C",3,11,14,16,19,21,23 "D",1,0,5 My desired output is: "A",1,0,10 "B",2,0,10 "B",2,15,20 "C",3,11,14 "C",3,16,19 "C",3,21,23 (4 Replies)
Discussion started by: kmsekhar
4 Replies

5. Shell Programming and Scripting

how to form Records[multiple line] between two known patterns

file contents looks like this : #START line1 of record1 line2 of record1 #END #START line1 of record2 line2 of record2 line3 of record2 #END #START line1 of record3 #END my question how should i make it a records between #START and #END . willl i be able to get the contents of the... (5 Replies)
Discussion started by: sathish92
5 Replies

6. Shell Programming and Scripting

Split a single record to multiple records & add folder name to each line

Hi Gurus, I need to cut single record in the file(asdf) to multile records based on the number of bytes..(44 characters). So every record will have 44 characters. All the records should be in the same file..to each of these lines I need to add the folder(<date>) name. I have a dir. in which... (20 Replies)
Discussion started by: ram2581
20 Replies

7. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

8. Shell Programming and Scripting

how first char in odd line and second char in even line

Hi I m having ifconfig -a o/p like sbanlab1:ksh# ifconfig -a | egrep "flags|inet" | awk -F' ' '{print $1,$2}' lo0: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> inet 127.0.0.1 lo0:1: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> inet 127.0.0.1 bge0:... (1 Reply)
Discussion started by: tarunn.dubeyy
1 Replies

9. UNIX for Dummies Questions & Answers

In BIND 9.3 DNS trying to get past the 256 char limit in SPF TXT records

One way I was told to do was incase strings in quotes. But I was given this option if I can get it to work. Will this work for splitting up SPF records? I am try to make bx.example.com reference spf.eu.***, spfa.eu.***, spfb.eu.***, and spfc.eu.***. spf.eu.example.com 3600 IN TXT "v=spf1... (0 Replies)
Discussion started by: tmanx
0 Replies

10. Shell Programming and Scripting

Change nth Char in a file..

I wanted to Replace if 20th Char is space then Replace by X .. 12345678901234567890 AAAA HEXW PROGRM01 (Ended by 3 Spaces ) Followed by junk(can be spaces als) BBBB HEXW PROGRM01 A0121225001 (Ended by 3 Spaces)Followed by junk I have Tired some thing of this sort ... cat... (4 Replies)
Discussion started by: pbsrinivas
4 Replies
Login or Register to Ask a Question