Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

adding a number with sed or awk.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting adding a number with sed or awk.
# 8  
Old 08-08-2012
I don't have access to Solaris/Awk to try it out, but this different approach might work:

Code:
nawk -F": " -v add=9 -v vals=telphoneNumber,emNotifNumber,billingnumber,BillingNumber ' 
    BEGIN{OFS=": ";split(vals,tmp,","); for(val in tmp) V[tmp[val]]}
     $1 in V {$2=add $2}
    $0~"=" {for(str in V) gsub(str"=", str"="add)} 1' infile

These 2 Users Gave Thanks to Chubler_XL For This Post:
Corona688 pelama
# 9  
Old 08-08-2012
Why do you know these things. Smilie LOL
# 10  
Old 08-08-2012
When you've lived on a farm as long as I have you learn to side step problems like that, LOL.
These 2 Users Gave Thanks to Chubler_XL For This Post:
pelama vgersh99
# 11  
Old 08-08-2012
Thanks a million..
# 12  
Old 09-06-2012
When I thought everything was hunky-dory

the first scenario was changing the numbers 01234567 to 901234567 and of course this was scenario changed.

Now I need to change the number from 01234567 to 091234567
Is that hard to change?
# 13  
Old 09-06-2012
How about:

Code:
nawk -F": " -v add=9 -v vals=telphoneNumber,emNotifNumber,billingnumber,BillingNumber ' 
    BEGIN{OFS=": ";split(vals,tmp,","); for(val in tmp) V[tmp[val]]}
    $1 in V {sub("^0*", "&"add, $2)}
    $0~"=" {for(str in V) gsub(str"=0*", "&"add)} 1' infile

# 14  
Old 09-06-2012
Seem to work fine.
I'm trying to understand,, what is does.. Smilie But.. No.. I don't get inte.. but a question,.
this "^0*" is that when it starts with a 0 or?

Thanks even more.. this time.. Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding text from a variable using sed (Or awk) with punctuation

Hi All, I would have though this would have been simple, but... I have text in a variable that I need to insert into a bunch of other files... The text is simple: ... (2 Replies)
Discussion started by: joeg1484
2 Replies

2. Shell Programming and Scripting

adding number based on pattern using awk

Hi, I want to add numbers based on pattern . in the below ouput file , i want number to be added after pattern line ---- , ie 1 and next is also 1 and next is 2 and next is 3 after adding 4 numbers say output is 7 should be redirected to another file . like this it should add 4 digits after... (2 Replies)
Discussion started by: raghavendra.nsn
2 Replies

3. Shell Programming and Scripting

Help on Sed/awk/getting line number from file

I Have file1 with below lines : #HostNameSelection=0 :NotUsed #HostNameSelection=1 :Automatic #HostNameSelection=3 :NotForced I have file2 which has similar lines but with different values I want to copy the changes from file1 to file2 ,line by line only if line begins with '#'. for... (7 Replies)
Discussion started by: mvr
7 Replies

4. Linux

Adding a prefix to a column using awk/sed commands

Hello, I am a newbie to linux and struggling to find a better way to append a column in a text file. Here is the file i want to modify: It has 8 columns (and thousands of rows). I want to append the first column by adding "chr" infront of the numbers. Some rows have a string in the first... (4 Replies)
Discussion started by: bjorngill
4 Replies

5. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Is there anyway to use awk to add a first column to my data that automatically goes from 1 to n , where n is the numbers of my rows?:confused: (4 Replies)
Discussion started by: cosmologist
4 Replies

6. Emergency UNIX and Linux Support

Adding carriage returns to file using sed/awk

Hello, I need help adding carriage returns at specific intervals (say 692 characters) to a text file that's one continous string. I'm working in AIX5.3. Any quick help is appreciated. Thanks! (2 Replies)
Discussion started by: bd_joy
2 Replies

7. Shell Programming and Scripting

sed/awk-adding numeric to a column

I have a txt file as follows Code: Oct 1 file1 4144 Oct 1 file23 5170 Oct 2 file5 3434 Oct 21 file56 2343 I need to add a new column by marking the right log file from current directory. For example populate like this. Please not in the second columt for "1" it has... (2 Replies)
Discussion started by: gubbu
2 Replies

8. Shell Programming and Scripting

awk/sed - getting string instead of number

Hi! I am writing a script handling downloading list of files and I have to check whether file is present locally and if not finished than continue downloading. To do so I have to compare sizes of remote file and local file. To check remote file size I have to parse something like this: ... (2 Replies)
Discussion started by: hrwath
2 Replies

9. UNIX for Dummies Questions & Answers

Adding a new field using sed or awk?

I have a bcp file that contains 10 fields. These fields are separated by a tab. How can I add my name as a new field in the 8th position for every record? I've been playing w/ sed and awk but can't seem to figure this out. (3 Replies)
Discussion started by: sasabune
3 Replies

10. UNIX for Dummies Questions & Answers

Truncating a number using sed/awk

Hi all, I'm trying to truncate a number like the following: 0001060407013900501048239559900600504083525826350002050354795057 I would like to create an output which puts carriage returns every so many characters, giving an output such as: 0001 060407 0139 0 05 010482395599 0060... (4 Replies)
Discussion started by: michaeltravisuk
4 Replies
Login or Register to Ask a Question