[Solved] Need to auto increment Post: 302883607

Sponsored Content

Top Forums Shell Programming and Scripting [Solved] Need to auto increment Post 302883607 by graphi on Wednesday 15th of January 2014 12:18:12 PM

01-15-2014

Registered User

[Solved] Need to auto increment

Hello, this is a VI question more than anything...

I'm using: SunOS 5.10 Generic_150400-04 sun4v sparc SUNW,T5240

I'm trying to find a problematic line(s) in a script.
The only solution I can think of is to tag each repetative line, and increment it.

This is an oracle insert script.

this line, "prompt inserting X" will echo "inserting X" to the STDOUT while the script executes.

So I have 20 different files that have inserts like the following:

insert into x (bla, bla, bla) values (1,2,3);

Each of those files has anywhere from 1500 to 110K+ repetitions of that line.
How can I run an automated script that edits the file and changes

"insert into xxxx"

into

"prompt inserting 1 -- for each iteration of this line, it needs to increment the number.
insert into xxxx"

That way when the file executes, I will see the incremented line number before the error it reports.

Thanks!

---------- Post updated at 10:18 AM ---------- Previous update was at 09:19 AM ----------

anyone?

Last edited by graphi; 01-15-2014 at 12:59 PM..

graphi

View Public Profile for graphi

Find all posts by graphi

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

increment an integer

hi I want to echo the variable $i while it auto-increments till 21 I set initially i to 1 any idea how to do that? thank you

2. Shell Programming and Scripting

Increment value (starttime)

Hi All, I have created a script... #!/bin/sh datafile=ABC2008101601.OUT indfile=ABCIND20081016.1.OUT waittime=600 starttime=0 while do if then echo "Indicator file has arrived." break else sleep 10; ((starttime=$starttime+10)) echo $starttime

3. Shell Programming and Scripting

auto increment

Hello Does anyone know how to auto-increment the value of a variable, preferably using awk or sed? I need to read values from a file and auto-increment those values to use them as line numbers I'd be doing: while read line do # auto-increment sed -n${line}p file> file1 done...

4. Shell Programming and Scripting

Increment in date

Hi, I have a variable lets say DATA_DATE. I have to pass some value to this variable in YYYYMMDD format. lets say today I have passed this variable as : DATA_DATE=20100107 Then pls help me how to calculate another variable DATA_DATE1 (which is DATA_DATE+1). The code should work...

5. Shell Programming and Scripting

[solved] merging two files and writing to another file- solved

i have two files as file1: 1 2 3 file2: a b c and the output should be: file3: 1~a 2~b 3~c

6. UNIX for Dummies Questions & Answers

[Solved] auto sftp

i was able to script: ftp -n hosname << DONE user username pwd put quite close DONE can i do same as sftp ? i tried, but it keeps asking for pwd. when i typed pwd, and it worked fine.

7. Shell Programming and Scripting

[Solved] How to increment and add variable length numbers to a variable in a loop?

Hi All, I have a file which has hundred of records with fixed number of fields. In each record there is set of 8 characters which represent the duration of that activity. I want to sum up the duration present in all the records for a report. The problem is the duration changes per record so I...

8. Shell Programming and Scripting

Increment the password value

I want a script which increments the count when the script runs. Basically I want to send an password reset email notification for an application, the password value should be keep on changing whenever the script is executed for example, first time i execute it should be password1, second time...

9. UNIX for Beginners Questions & Answers

Howto auto boot SPARC | How to auto supply "start /SYS" and "start /SP/console" commands

When I power ON my T4-1, I got a prompt -> where I have to start /SYS and start /SP/console. How can I auto supply these two commands ?

LEARN ABOUT DEBIAN

makesh

MAKESH(1)						      General Commands Manual							 MAKESH(1)

NAME

       makeSH - a .SH script maker

SYNOPSIS

       makeSH files

DESCRIPTION

       MakeSH  examines  one or more scripts and produces a .SH file that, when run under sh, will produce the original script.  The .SH script so
       produced has two sections containing code destined for the output.  The first section has variable substitutions performed  on  it  (taking
       values  from  config.sh), while the second section does not.  MakeSH does not know which variables you want to have substituted, so it puts
       the whole script into the second section.  It's up to you to insert any variable substitutions in the first section for any values you want
       from config.sh.

       You  should  run  makeSH from within your top-level directory and use the relative path to the file as an argument, so that the "Extracting
       ..." line printed while running the produced .SH file later on will give that same path.

AUTHOR

       Larry Wall <lwall@netlabs.com>

SEE ALSO

       pat(1), metaconfig(1), makedist(1).

BUGS

       It could assume that variables from metaconfig's Glossary need to be initialized in the first section, but I'm too lazy to make it do that.

								       LOCAL								 MAKESH(1)