9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear all,
I 'd like to ask a question. I have two datasets: a.txt (only has one filed, call 'SNP'), b.txt( has thousands of fields, 1st field call 'SNP').
a.txt:
rs9527
rs318567
rs12376
...
b.txt:
rs167893 1 2 0 2 1 2 ...
rs318567 2 0 2 1 2 0 ...
rs12376 0 2 0 2 1 2 ...
I... (2 Replies)
Discussion started by: forevertl
2 Replies
2. Shell Programming and Scripting
Hoping for some assistance.
my source file consists of:
os, ip, username
win7, 123.56.78, john
win7, 123.56.78, paul
win7, 10.1.1.1, john
win7, 10.2.2.3, joe
I've been trying to run a script that will only return ip and username where the IP address is the same and the username is... (3 Replies)
Discussion started by: tekvaio
3 Replies
3. Shell Programming and Scripting
Hi Guys,
I’m struggling to use two fields to do a duplicate/ unique by output.
I want to look IP addresses assigned to more than one account during a given period in the logs. So duplicate IP and account > 1 then print all the logs for that IP. I have been Using AWK (just as its installed... (3 Replies)
Discussion started by: wabbit02
3 Replies
4. Shell Programming and Scripting
Hi,
I am new to UNIX. Can some one help me to solve the below.
I have a requirement to to identify the specific fields in row and also some part of the field.
In my file I have a record as
sundra;10.44.48.65;10thstreet TCP packet out of state: First packet isn't SYN;telno:... (3 Replies)
Discussion started by: suneel.mekala
3 Replies
5. Shell Programming and Scripting
I need to write a program to do something like a 'vlookup' in excel. I want to match data from file2 based on two fields (where both match) in file1, and for matching lines, add the data from two of the fields from file2 to file1.
If anyone knows something in perl or awk that can do this, I'd be... (20 Replies)
Discussion started by: jamessmith01
20 Replies
6. Shell Programming and Scripting
I have a file that is large and is broken up by groups of data. I want to take certain fields and display them different to make it easier to read. Given input file below:
2008 fl01 LAC 2589 polk doal
xx 2008q1 mx
sect 25698541
Sales 08 Dept group
lead1 ... (8 Replies)
Discussion started by: timj123
8 Replies
7. UNIX for Dummies Questions & Answers
How would I find three different fields in a data file such as first name, last name, credit card number in a particular file?
Thanks in advance for your help (3 Replies)
Discussion started by: damion
3 Replies
8. UNIX for Dummies Questions & Answers
I would like some sugestions on how to solve the following problem with removing selected data from fields. Each day I receive a file containing 22,000 records that I use a combination of awk and the cut command to remove unwanted fields. This is a work in process as I learn more about awk, sed... (4 Replies)
Discussion started by: greengrass
4 Replies
9. Shell Programming and Scripting
Dear All,
I have some data file.see below.
--------------ALARM CLEARING FROM SubNetwork=ONRM_RootMo,SubNetwork=AXE,ManagedElement=CGSN--------------
Alarm Record ID: 25196304
Event Time: 2006-08-28 13:41:35
Event Type: ... (1 Reply)
Discussion started by: Nayanajith
1 Replies
gdbload(1) HP100LX Tools gdbload(1)
NAME
gdbload - load ASCII formatted data into an HP 100LX database
SYNOPSIS
gdbload [-an] database [ input ]
DESCRIPTION
gdbload loads ASCII formatted data into an HP 100LX database. database is the name of the 100LX database to modify. input is the name of
a file of ASCII data to load into the database. If no input file is specified, the standard input is used. The ASCII file format is one
exported by many database packages as well as by gdbdump(1).
Options
gdbload recognizes the following options:
-a Add the records from the ASCII file to the database, keeping the records already present in the database. By default, the
records in the ASCII file replace those already in the database.
-n Do not back up the database file. By default, the original, unmodified database file is left in a file with the same name
and a .bak extension.
Input Format Description
The input to this program is an ASCII text file which starts with a line containing field names. This line indicates the order in which
fields appear on subsequent lines. Not all fields of the database need be specified; unspecified fields will be left blank in all added
records. Field names are not case distinct and ampersands (&) are ignored in comparing field names.
This first line is followed by one line for each record of the database. Note that any of these lines may be split into multiple lines if
needed, by placing a backslash () at the ends of lines which are continued. Also note that string fields may span multiple lines provided
they are quoted. Apart from line splitting according to these rules, each "logical" line contains all of the fields whose names were
listed on the first line, in the same order as on the first line. The fields (and the field names, on the first line) are separated by
commas.
Exactly how each field should appear depends on its type. Text fields, category fields, number fields, and note fields should have their
text quoted if it contains commas or newlines. The following escape sequences are understood:
Carriage return (ASCII 13).
Line feed (ASCII 10).
nn nnn are octal digits representing a character.
xnn nn are hexadecimal digits representing a character.
Any other character following a backslash is treated as a standard character with no special meaning, i.e., backslash and quote marks can
be escaped by preceding them with a backslash.
Date fields should appear in the format YYYYMMDD; for example, August 15, 1993 should appear as 19930815. Time fields appear in the format
HHMM, where HH is in the range 00-23. Date and time fields may also be left blank, i.e., nothing between the commas.
Radio buttons and check boxes are turned off if the field is empty or contains a 0; they are turned on otherwise.
No other field types, including application-defined types, are accepted by gdbload.
The output from gdbdump(1) matches this input format, unless the -n flag is given to gdbdump(1).
WARNINGS
When the newly constructed database is first opened by the 100LX, it will (erroneously) be reported as being empty. This is because gdbload
does not construct database indexes, and the 100LX expects the index for the current "subset" to be valid. The situation is remedied by
pressing F6 and selecting any "subset" (even the current one!) This will rebuild the index for that "subset", causing records to display
normally. The delay caused by the rebuild depends on the size of the database (among other things), and ranges from imperceptible for
small databases up to several minutes. This delay will occur whenever a new "subset" is selected for the first time.
gdbload will not attempt to modify HP 100LX Appointment Book and World Time databases.
gdbload will not allow you to specify data for application-defined fields of a database.
This program cannot handle password-protected databases. Attempts to load data into password-protected databases will have unpredictable
results.
AUTHOR
gdbload was written by Steven Roth, stever@cup.hp.com, and is being maintained by Arne Christensen, arc@pine.dk. Contact the latter for
bug reports, enhancement requests, or to get a copy of the source code.
DISCLAIMER
This program is released into the public domain and neither the author nor the maintainer place any restrictions on its use. We make no
warranties or guarantees for this program and you use it at your own risk. This program is supplied by us personally and not by Hewlett-
Packard Co. or Pine Tree Systems, which incur no obligations pertaining to it.
ACKNOWLEDGEMENTS
Many thanks to Andy Gryc for publishing the details of the database file formats!
SEE ALSO
gdbdump(1).
Steve Roth et.al. February 1996 gdbload(1)