Sponsored Content
Top Forums Shell Programming and Scripting Remove somewhat Duplicate records from a flat file Post 302560289 by ahamed101 on Thursday 29th of September 2011 11:16:11 AM
Old 09-29-2011
so whats the key? 123456789?

--ahamed
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting records from flat file to db table

I have 20000 numbers present in a file in each line like 25663, 65465, 74579, 56446, .. .. I have created a table in db with single number column in it. create table testhari (no number(9)); I want to insert all these numbers into that table. how can i do it? can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies

2. Shell Programming and Scripting

Remove all instances of duplicate records from the file

Hi experts, I am new to scripting. I have a requirement as below. File1: A|123|NAME1 A|123|NAME2 B|123|NAME3 File2: C|123|NAME4 C|123|NAME5 D|123|NAME6 1) I have 2 merge both the files. 2) need to do a sort ( key fields are first and second field) 3) remove all the instances... (3 Replies)
Discussion started by: vukkusila
3 Replies

3. Solaris

How to remove duplicate records with out sort

Can any one give me command How to delete duplicate records with out sort. Suppose if the records like below: 345,bcd,789 123,abc,456 234,abc,456 712,bcd,789 out tput should be 345,bcd,789 123,abc,456 Key for the records is 2nd and 3rd fields.fields are seperated by colon(,). (2 Replies)
Discussion started by: svenkatareddy
2 Replies

4. Shell Programming and Scripting

How to remove duplicate records with out sort

Can any one give me command How to delete duplicate records with out sort. Suppose if the records like below: 345,bcd,789 123,abc,456 234,abc,456 712,bcd,789 out tput should be 345,bcd,789 123,abc,456 Key for the records is 2nd and 3rd fields.fields are seperated by colon(,). (19 Replies)
Discussion started by: svenkatareddy
19 Replies

5. Shell Programming and Scripting

Sorting the records in the Flat file

Hi all, I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat. Can any tell me how to sort the file except first line in the file For ex: i/p First line: DXYZ Second line : jumy third : cmhk fourth : andy Output should... (5 Replies)
Discussion started by: sudhir_barker
5 Replies

6. Shell Programming and Scripting

How do I load records from table to a flat file!

Hi All, I need to load records from oracle table XYZ to a flat file say ABC.dat. could any one tell me how do i do this in UNXI, Regards Ann (1 Reply)
Discussion started by: Haque123
1 Replies

7. Shell Programming and Scripting

Remove duplicate records

I want to remove the records based on duplicate. I want to remove if two or more records exists with combination fields. Those records should not come once also file abc.txt ABC;123;XYB;HELLO; ABC;123;HKL;HELLO; CDE;123;LLKJ;HELLO; ABC;123;LSDK;HELLO; CDF;344;SLK;TEST key fields are... (7 Replies)
Discussion started by: svenkatareddy
7 Replies

8. Shell Programming and Scripting

Remove Duplicate Records

Hi frinds, Need your help. item , color ,desc ==== ======= ==== 1,red ,abc 1,red , a b c 2,blue,x 3,black,y 4,brown,xv 4,brown,x v 4,brown, x v I have to elemnet the duplicate rows on the basis of item. the final out put will be 1,red ,abc (6 Replies)
Discussion started by: imipsita.rath
6 Replies

9. Shell Programming and Scripting

Deleting duplicate records from file 1 if records from file 2 match

I have 2 files "File 1" is delimited by ";" and "File 2" is delimited by "|". File 1 below (3 record shown): Doc1;03/01/2012;New York;6 Main Street;Mr. Smith 1;Mr. Jones Doc2;03/01/2012;Syracuse;876 Broadway;John Davis;Barbara Lull Doc3;03/01/2012;Buffalo;779 Old Windy Road;Charles... (2 Replies)
Discussion started by: vestport
2 Replies

10. Shell Programming and Scripting

Remove duplicate records

Hi, i am working on a script that would remove records or lines in a flat file. The only difference in the file is the "NOT NULL" word. Please see below example of the input file. INPUT FILE:> CREATE a ( TRIAL_CLIENT NOT NULL VARCHAR2(60), TRIAL_FUND NOT NULL... (3 Replies)
Discussion started by: reignangel2003
3 Replies
NILOAD(8)						      System Manager's Manual							 NILOAD(8)

NAME
niload - load text or flat-file-format data into NetInfo SYNOPSIS
niload [ -v ] [ -d ] [ -m ] [ -p ] [ -t ] { -r directory | format } domain DESCRIPTION
niload loads information from standard input into the given NetInfo domain. If format is specified, the input is interpreted according to the flat-file file format of the same name. The allowed values for format are aliases, bootparams, bootptab, exports, fstab, group, hosts, networks, passwd, printcap, protocols, rpc, and services. If -r directory is specified instead of a flat-file file format, the input is interpreted as "raw" NetInfo data, as generated by nidump -r, and loaded into directory. Note that this operation will delete and replace the entire NetInfo subtree at the specified directory. Any existing records in this subtree will be lost. niload overwrites entries in the existing directory with those given in the input. Entries that are in the directory aren't deleted if they don't exist in the input, unless the -d option is specified. niload must be run as superuser on the master NetInfo server for the given domain, unless one specifies the -p option, which allows one to run from anywhere in the network. OPTIONS
-v Verbose. Prints details of records as they are updated (flat-file formats only). -d Delete entries which are in the directory, but not in the input. -m Merge properties and values. Existing properties will be preserved in the database if they are not present in the input. For exam- ple, if a user record has a "picture" property, loading a passwd-format record for this user will preserve the property. Property values are also merged. -p Prompt for the root password of the given domain so that one can run from other locations in the network besides the master. -t Interpret the domain as a tagged domain. For example, "trotter/network" refers to the database tagged "network" on the machine "trotter". The machine name can be an actual name or an IP address. -r Load entries in "raw" format, as generated by nidump -r. The first argument should be the path of a NetInfo directory into which the information is loaded. Since the input often specifies properties (including "name") at its topmost level, the directory you specify may be renamed as a result of this operation. If the directory you specify does not exist, it will be created. EXAMPLES
"niload passwd . < /etc/passwd" loads the local /etc/passwd file into the local NetInfo database. "niload -d -r /locations ." replaces the contents of /locations in the local domain with input given in nidump "raw" format. SEE ALSO
nidump(8), niutil(8), netinfo(5), aliases(5), bootparams(5), bootptab(5), exports(5), fstab(5), group(5), hosts(5), networks(5), passwd(5), printcap(5), protocols(5), rpc(5), services(5) Apple Computer, Inc. December 22, 1992 NILOAD(8)
All times are GMT -4. The time now is 06:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy