Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

editing line in text file adding number to value in file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting editing line in text file adding number to value in file
# 8  
Old 01-20-2012
I changed that of course, but when I run exactly as you've put it, I get:

Code:
Data        "1000001#15"
{
  CreateTime           ""
  1000000                   1

I'm actually running this on AIX, but I wouldn't expect the implementation of awk to be that different.
# 9  
Old 01-20-2012
I think it is because Id is not at the beginning of the line...
Try this instead:
Code:
awk '/^Data/{split($2,N,"[#\"]");n=N[2]} /^ID/{n=$2} {sub(n,n+1000000)}1' infile

Change to Id if required...
# 10  
Old 01-20-2012
I thought it worked fine, but when I applied to my full file, it seems to be adding 1000000 to other occurrences of 1, so

Code:
  Updated           "UTC 20120112 16:30:05"

becomes

Code:
  Updated           "UTC 20100000120112 16:30:05"

it seems to be adding 1000000 to every first occurrence of 1 on each line
# 11  
Old 01-20-2012
Slowly, but surely Smilie
Code:
awk '/^Data/{split($2,N,"[#\"]");n=N[2]} /^I[dD]/{n=$2} n""{sub(n,n+1000000);n=x}1' infile

# 12  
Old 01-20-2012
:-)

Now it ignores Id completely

Code:
Data        "1000001#15"
{
  CreateTime           ""
  Id                   1

# 13  
Old 01-20-2012
Id doesn't start at the beginning of the line. Modifying the regex slightly should fix this:
Code:
awk '/^Data/{split($2,N,"[#\"]");n=N[2]} / *I[dD]/{n=$2} n""{sub(n,n+1000000);n=x}1'

# 14  
Old 01-23-2012
It's now doing something very odd:
Code:
Data        "1#15"
{
  CreateTime           ""
  Id                   1
  AAId                 20
  LongName             "NO VALID ENTRY"

is becoming:
Code:
Data        "1000001#15"
{
  CreateTime           ""
  Id                   1000001
  AAId                 1000020
  LongName             1000000 VALID ENTRY"

so the AAId is being changed, and "NO is being changed too
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding user name to file, and then displaying new line number

Hi all - I'm completely stumped by a script I'm working on... The short version is I have a file called 'lookup' and in it are hundreds of names (first and last). I have a script that basically allows the user to enter a name, and what I need to have happen is something like this: Record... (8 Replies)
Discussion started by: sabster
8 Replies

2. UNIX for Dummies Questions & Answers

[Help] Adding text to a variable line in a file

Hey guys, I need to write a script that will add a specific text at the end of a specific line (of a text file). but the line is a variable this is my text file : device_2 ansible_ssh_host=127.0.0.1 ansible_ssh_port=30000 ansible_ssh_user='root' device_2 ansible_ssh_host=127.0.0.1... (1 Reply)
Discussion started by: OdedOvdat
1 Replies

3. Shell Programming and Scripting

Adding filename and line number from multiple files to final file

Hi all, I have 20 files (file001.txt upto file020.txt) and I want to read them from 3rd line upto end of file (line 1002). But in the final file they should appear to start from line 1. I need following kind of output in a single file: Filename Line number 2ndcolumn 4thcolumn I... (14 Replies)
Discussion started by: bioinfo
14 Replies

4. Shell Programming and Scripting

Adding text to the end of the specific line in a file(only to the first occurrence of it)

Hi, I want to add a text to the end of the specific line in a file. Now my file looks like this: 999 111 222 333 111 444 I want to add the string " 555" to the end of the first line contaning 111. Moreover, I want to insert a newline after this line containg the "000" string. The... (8 Replies)
Discussion started by: wenclu
8 Replies

5. Shell Programming and Scripting

adding line number to *end* of records in file

Given a file like this: abc def ghi I need to get to somestandardtext abc1 morestandardtext somestandardtext def2 morestandardtext somestandardtext ghi3 morestandardtext Notice that in addition to the standard text there is the line number added in as well. What I conceived is... (4 Replies)
Discussion started by: edstevens
4 Replies

6. Shell Programming and Scripting

adding a line to a text file

I have a tab delimited text file, id name distance 1 3325167 0.334561754018 2 3290488 0.389444269458 3 3288794 0.392312701782 4 3347602 0.392532202097 5 3295355 0.394394169485 I need to add a line after the header line. The first and third field of... (3 Replies)
Discussion started by: LMHmedchem
3 Replies

7. Linux

Get a specific line number from a text file

Hello! All, Could you please tell me how to get a specific line number from a text file? For example below, ABC DEF ---> Get this line number, return to an variable GHI My OS is Linux. Thank you so much for your help in advance! (3 Replies)
Discussion started by: barryxian
3 Replies

8. Shell Programming and Scripting

Adding specific text and spaces to each line in a text file

Hi, I wanted to add specific text to each row in a text file containing three rows. Example: 0 8 7 6 5 5 7 8 9 0 7 9 7 8 9 0 1 2 And I want to add a 21 at the beginning of the first row, and blank spaces at the beginning of the second two rows. To get this: 21 0 8 7 6 5 5 7 8... (4 Replies)
Discussion started by: hertingm
4 Replies

9. Shell Programming and Scripting

adding text to end of each line in a file

I'm needing to add a "hour:min" to the end of each line in a document. The document in this case is only going to be one line. if this inserts it at the end, what needs to be changed to add something at the end... /bin/echo "%s/^/$filler/g\nwq!" | ex -s $oFile Thank you... (2 Replies)
Discussion started by: cubs0729
2 Replies

10. Shell Programming and Scripting

Adding Text To each line of a file

How would I add text to the beginning of each line in a text file in a script right after the file is created from another text file. (4 Replies)
Discussion started by: cubs0729
4 Replies
Login or Register to Ask a Question