Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: insert pipes for existing and non-existing records
Top Forums Shell Programming and Scripting insert pipes for existing and non-existing records Post 302329614 by kshji on Monday 29th of June 2009 03:59:28 AM
Old 06-29-2009
1st field is the keyfld ?

Code:
#!/usr/bin/ksh
previd=""
record=""
delimeter="|"
maxrec=12
id=""
restvalues=""

function initrec
{
  i=1
  while ((i<=maxrec))
  do
        rec[$i]=""
        ((i+=1))
  done
}

function printrec
{
  i=1
  record=""
  while ((i<=maxrec))
  do
        record="$record${rec[$i]}$delimeter"
        ((i+=1))
  done
  print "$record"
  initrec
}


function saverec
{
    recnr=${restvalues:12:2}
    rec[$recnr]="$id $restvalues"
}


##MAIN####
initrec

while read id restvalues
do
       [ "$previd" = "" ] && previd="$id"  # 1st line
       [ "$id" != "$previd" ] && printrec && previd="$id" && continue # nextline
       saverec
       previd="$id"
done
# and last ...
printrec

Code:
chmod a+rx thisscript
cat somefile |  sort -t " " -k 1,1 | ./thisscript > out.txt

Last edited by kshji; 06-29-2009 at 05:27 AM..
 

10 More Discussions You Might Find Interesting

1. Programming

link a new .so with an existing .so

I have an existing C module that already built libudf.so Now I have modify this module to call a third party software function (which is new.so), and re build to target to libudf.so I compiled that includes all header files of third party software. Linking to new.so is also good, But when... (0 Replies)
Discussion started by: baosoccer
0 Replies

2. Shell Programming and Scripting

script to run shell command and insert results to existing xml file

Hi. Thanks for any help with this. I'm not new to programming but I am new to shell programming. I need a script that will 1. execute 'df -k' and return the volume names with specific text 2. surround each line of the above results in opening and closing xml tags 3. insert the results of step... (5 Replies)
Discussion started by: littlejon
5 Replies

3. Shell Programming and Scripting

folder existing and file existing

I want to look into a folder to see if there are any folders within it. If there are, I need to check inside each folder to see if it contains a .pdf file So If /myserver/myfolder/ contains a folder AND that folder conatins a .pdf file do X Else do Z I may have multiple folders and... (4 Replies)
Discussion started by: crowman
4 Replies

4. Shell Programming and Scripting

Need to insert new text and change existing text in a file using SED

Hi all, I need to insert new text and change existing text in a file. For that I used the below line in the command line and got the expected output. sed '$a\ hi... ' shell > shell1 But I face problem when using the same in script. It is throwing the error as, sed: command garbled:... (4 Replies)
Discussion started by: iamgeethuj
4 Replies

5. Shell Programming and Scripting

how to insert text between lines of an existing file using perl

Hi , I need some inputs on how to open a file (file.txt) and parse the text example aaa of the file and bbb of the file and add the text zzzz once i parse (aaa and bbb) and followed by the remaining of the text as it is in the file using perl programming. Thanks in advance (3 Replies)
Discussion started by: madhul2002
3 Replies

6. Solaris

Add existing user into an existing group

Pre: no gpasswd/adduser there is just usermod can be used, also there is no -a option for usermod. How should I add a user into a group? (4 Replies)
Discussion started by: a2156z
4 Replies

7. Shell Programming and Scripting

Adding existing set of records in the same file

I have a file with 50,000 records in it, i have a requirement to use the same 50,000 records and add them 4 times to the same file to make a total of 200,000 records. I was wondering how to do this using ksh. Any help is greatly appreciated. (2 Replies)
Discussion started by: vpv0002
2 Replies

8. UNIX for Dummies Questions & Answers

Appending lines from an existing list to each line in another existing list

Evening all ! I would like to ask your expertise on how to accomplish the following ; I have 2 lists, and would like each line from list2 to be appended to each line in list1, resulting in list3 ; List1; alpha beta charlie List2; one two three (4 Replies)
Discussion started by: TAPE
4 Replies

9. Shell Programming and Scripting

Append to existing line

I have a file which has lines that end with a plus (+) sign. I would like to get the next line appended to the one with the plus. For example bla bla bla bla bla + blip blip blip would become bla bla bla bla bla blip blip blip However not all lines end with a plus sign . I would... (2 Replies)
Discussion started by: bombcan
2 Replies

10. Shell Programming and Scripting

Check existing

deleted (2 Replies)
Discussion started by: ust3
2 Replies

LEARN ABOUT OPENSOLARIS

env

env(1)								   User Commands							    env(1)

NAME

       env - set environment for command invocation

SYNOPSIS

       /usr/bin/env [-i | -] [name=value]... [utility [arg... ]]

       /usr/xpg4/bin/env [-i | -] [name=value]...
	    [utility [arg... ]]

DESCRIPTION

       The  env utility obtains the current environment, modifies it according to its arguments, then invokes the utility named by the utility op-
       erand with the modified environment.

       Optional arguments are passed to utility. If no utility operand is specified, the resulting environment is written to the standard  output,
       with one name=value pair per line.

   /usr/bin
       If env executes commands with arguments, it uses the default shell /usr/bin/sh (see sh(1)).

   /usr/xpg4/bin
       If env executes commands with arguments, it uses /usr/xpg4/bin/sh (see ksh(1)).

OPTIONS

       The following options are supported:

       -i | -	     Ignores  the  environment that would otherwise be inherited from the current shell.  Restricts the environment for utility to
		     that specified by the arguments.

OPERANDS

       The following operands are supported:

       name=value     Arguments of the form name=value modify the execution environment, and are placed  into  the  inherited  environment  before
		      utility is invoked.

       utility	      The  name of the utility to be invoked.  If utility names any of the special shell built-in utilities, the results are unde-
		      fined.

       arg	      A string to pass as an argument for the invoked utility.

EXAMPLES

       Example 1 Invoking utilities with new PATH values

       The following utility:

	 example% env -i PATH=/mybin mygrep xyz myfile

       invokes the utility mygrep with a new PATH value as the only entry in its environment. In this case, PATH is used to locate  mygrep,  which
       then must reside in /mybin.

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of env: LANG, LC_ALL, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

       PATH    Determine the location of the utility. If PATH is specified as a name=value operand to env, the value given shall be  used  in  the
	       search for utility.

EXIT STATUS

       If  utility  is invoked, the exit status of env is the exit status of utility. Otherwise, the env utility returns one of the following exit
       values:

       0	 Successful completion.

       1-125	 An error occurred.

       126	 utility was found but could not be invoked.

       127	 utility could not be found.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

   /usr/bin
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |enabled			   |
       +-----------------------------+-----------------------------+

   /usr/xpg4/bin
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWxcu4			   |
       +-----------------------------+-----------------------------+
       |CSI			     |enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       ksh(1), sh(1), exec(2), profile(4), attributes(5), environ(5), standards(5)

SunOS 5.11							    2 Jan 2002								    env(1)
All times are GMT -4. The time now is 04:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy