Set of 2 records as one unit Post: 302558753

Sponsored Content

Top Forums Shell Programming and Scripting Set of 2 records as one unit Post 302558753 by PG3 on Sunday 25th of September 2011 07:24:08 AM

09-25-2011

Registered User

Scrutinizer,

Yes, after a second glance, I realized the extra "]" and when I took out, it just ran well.

Sure here is the sample set of records with 3 records instead of two.

Code:

11393 18.77(E) AUTH 43034
11393 23.77(E) PRES 43034
11393 23.77(E) SETT 43034


11571 25.03(E) AUTH 39840002
11571 34.53(E) PRES 39840002
11571 34.53(E) SETT 39840002


11884 76.29($) AUTH 4954884
11884 90.29($) PRES 4954884
11884 90.29($) SETT 4954884

and out of these, I just want the Account numbers as below and I dont want anymore details(& I just realized that now)

Code:

11393
11571
11884

as these are the values that are stored in Oracle and Im just trying to create a look up file so that sqlloader can insert these records into the db.

Finally, thanks a bunch on your help.

regards,
PGonzalez.

Last edited by Scott; 09-25-2011 at 08:30 AM.. Reason: Code tags

PG3

View Public Profile for PG3

Find all posts by PG3

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Cutting a limited or given set of records in a datbase

I need to select "cut" a certain number of records in a database. ie. records 20 to 25. Help

2. Shell Programming and Scripting

Getting MAC from GPS unit

Never mind i got the answer thanks.,

3. UNIX for Dummies Questions & Answers

seperating records with numbers from a set of numbers

I have two files one (numbers file)contains the numbers(approximately 30000) and the other file(record file) contains the records(approximately 40000)which may or may not contain the numbers from that file. I want to seperate the records which has the field 1=(any of the number from numbers...

4. Shell Programming and Scripting

Based on num of records in file1 need to check records in file2 to set some condns

Hi All, I have two files say file1 and file2. I want to check the number of records in file1 and if its atleast 2 (i.e., 2 or greater than 2 ) then I have to check records in file2 .If records in file2 is atleast 1 (i.e. if its not empty ) i have to set some conditions . Could you pls...

5. Shell Programming and Scripting

extract set of matching records

i have a pipe delimited file with records spread in many lines. i need to extract those records 1)having X in beginning of that record 2)and having at least one Y in beginning before other record begins eg: X|Rec1| A|Rec1| Y|Rec1| X|Rec2| Y|Rec2| Z|Rec3| X|Rec4| M|Rec4| ...

6. 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.

7. HP-UX

Load average unit

Hi, On load average graph, unit is 100m, 200m, 300...800m. I don't understand what it means. Thx for helping

8. Shell Programming and Scripting

Compare two files with different number of records and output only the Extra records from file1

Hi Freinds , I have 2 files . File 1 |nag|HYd|1|Che |esw|Gun|2|hyd |pra|bhe|3|hyd |omu|hei|4|bnsj |uer|oeri|5|uery File 2 |nag|HYd|1|Che |esw|Gun|2|hyd |uer|oi|3|uery output :

9. UNIX for Dummies Questions & Answers

Simple unit script

Hello guys this is my first post in this forum. Since now ive been passive an ive only been looking for existing information. Now I could use specific help on a UNIX script i want to make that would: 1. Take 1-3 arguments. 2. Display the contents of its arguments, formatted as follows:...

LEARN ABOUT DEBIAN

amtterm

amtterm(1)						      General Commands Manual							amtterm(1)

NAME

       amtterm - Intel AMT serial-over-lan (sol) client.

SYNOPSIS

       amtterm [ options ] host [ port ]

DESCRIPTION

       amtterm	provides access to the serial-over-lan port of Intel AMT managed machines.  host is the hostname or IP address of the machine amt-
       term should connect to.	port is the tcp port to use and defaults to 16994 (standard AMT redirection port) if unspecified.

       For more inforamtions on Intel AMT check amt-howto(7).

OPTIONS

       -h     Display help text.

       -v     Be verbose (default).

       -q     Be quiet.

       -u <user>
	      Specify username, defaults to "admin".

       -p <pass>
	      Specify password.  amtterm will prompt on the terminal if unspecified.

ENVIRONMENT

       AMT_PASSWORD
	      Default value for the password.

SEE ALSO

       gamt(1), amttool(1), amt-howto(7)

AUTHOR

       (c) 2007 Gerd Hoffmann <kraxel@redhat.com>

							      (c) 2007 Gerd Hoffmann							amtterm(1)